Hi Max,

There are a few ways to do this. Here's one:

1. 4 columns of data, in a1=Product, b1=ProductID, c1=ProductDesc, d1=IDDesc

2. In the rows underneath put the appropriate info. (except for d2 and
down). I used this info. a2=Pens, Black Ink, a3=Pens, Blue Ink, a4=Pens, Red
Ink. B2 through B4 is 1 to 3. c2=Pens that write in Black Ink, c3=Pens that
write in Blue Ink, and c4=Pens that write in Red Ink.

3. In cell D2 type in:
=B2 & ". " & C2. You can also use concatenate, which essentially does the
same thing.

4. Now in cell A10, go to insert, name, define, type in Product, highlight
the pens in column a, add close.

5. Go to Data, validation, allow list, type in =Product

6. In cell b10 put in:
=VLOOKUP(A10,A1:D4,4)

Hope this answers your question.