Novice needing help!!!

[Guest]

Hi,
I have a created an invoice, and a stocklist, on separate worksheets in a
workbook using EXCEL 2003. On the stocklist worksheet, I have lot number
1-500 in Column A, and a description for each in Column B, and I want to
enter a number in Columb A on the invoice worksheet and have the
corresponding description come up in Column B on the invoice......So that if
someone buys lot number 100, I can enter "100" into Column A in the invoice
worksheet and have that description show up in Column B.
Your advice will be very much appreciated.

 

[Guest]

Try the VLOOKUP function.....

On the STOCKLIST sheet
A1: LOTNUM
A2:A501 contains Lot Numbers (1:500)
B1: DESC
B2:B501 contains Lot Descriptions

Then
On the INVOICE sheet
A2: (a LOTNUM value)
B2: =IF(A2="","",VLOOKUP(A2,STOCKLIST!$A$2:$B$500,2,0))

Copy B2 down as far as you need.

Those are the basics. For lots more information on how to use VLOOKKUP see
Debra Dalgleish's website:
http://www.contextures.com/xlFunctions02.html

Does that help?
***********
Regards,
Ron

XL2002, WinXP

 

[Guest]

My first post had a typo in a range ref to the STOCKLIST sheet
......this one is corrected.

Try the VLOOKUP function.....

On the STOCKLIST sheet
A1: LOTNUM
A2:A501 contains Lot Numbers (1:500)
B1: DESC
B2:B501 contains Lot Descriptions

Then
On the INVOICE sheet
A2: (a LOTNUM value)
B2: =IF(A2="","",VLOOKUP(A2,STOCKLIST!$A$2:$B$501,2,0))

Copy B2 down as far as you need.

Those are the basics. For lots more information on how to use VLOOKKUP see
Debra Dalgleish's website:
http://www.contextures.com/xlFunctions02.html

Does that help?
***********
Regards,
Ron

XL2002, WinXP

 

[Guest]

Thanks so much Ron, it worked!!!!