The new forums will be named Coin Return (based on the most recent vote)! You can check on the status and timeline of the transition to the new forums here.
The Guiding Principles and New Rules document is now in effect.
I'm trying to make some sheets for my boss to use when doing estimates on various items. Basically i want to type in the item number and bring up information from another document such as name cost per unit etc. I'm just having some trouble with the addressing.
basically thats what one of the documents looks like, I'm having trouble with the incrementing on the other document with is pretty much fill in the blank once the item number is entered.
You want a LOOKUP function. Excel has a nice help system, so read up on VLOOKUP for example. It can do what you want, including getting data from a second excel file / workbook based on a product code.
Posts