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.

Excel Question

bbmartinibbmartini Registered User regular
edited June 2008 in Help / Advice Forum
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.

50460098ng0.jpg

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.

camo_sig2.png
bbmartini on

Posts

  • ZonkytonkmanZonkytonkman Registered User regular
    edited June 2008
    i'm having a really hard time understanding what you're asking

    Zonkytonkman on
  • WheezerWheezer Registered User regular
    edited June 2008
    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.

    Wheezer on
    megamansig.jpg
Sign In or Register to comment.