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.