I have made a drop-down list of different items (text). I want to have each
item's respective price (currency) populate the adjacent column after that
item is picked from the list.

I first tried imbedded conditional "if" statements where if the text chosen
on the list was equal to the text in a particular cell, the contents of
another cell (the price) would be displayed. This worked well for me until I
got past 7 imbedded "if" statements for the particular cell; then I would get
an error.

Since I need to do this for more items, I tried to make a drop-down list
from the two columns (item description and price), but found out you can only
make a list from a single column or row.

Any suggestions?

Thanks,
Keith