Item numbers result in item description in next field in Excel
 

I am putting a spreadsheet together and I want the item number to
automatically populate the item description in the next field. Can anyone
give me an answer about what syntax I should be using?
For example: In cell B5 I would enter item #123 (I have item #'s in a drop
down) - I would like cell C5 to automatically display the description of 3"
Pipe.

Item numbers result in item description in next field in Excel
 

You need VLOOKUP, see http://www.contextures.com/xlFunctions02.html

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Cheryl MM" <Cheryl wrote in message
...
I am putting a spreadsheet together and I want the item number to
automatically populate the item description in the next field. Can anyone
give me an answer about what syntax I should be using?
For example: In cell B5 I would enter item #123 (I have item #'s in a drop
down) - I would like cell C5 to automatically display the description of
3"
Pipe.