adding a price to an item in a drop-down list

[Nat]

Okay, I have created a data-validation for a list of items, however, i need the list, so that whatever item you pick from the list produces a price into the adjacent cell? Can anyone help???

 

[Tom Ogilvy]

look in help at the Vlookup function. The first argument would be the cell
with the data validation. The second would be the range where you have the
items listed with there prices in the next column over (same row).

Then the third argument would be 2 (or if the prices are farther away then
the next column, the appropriate number of columns) and the forth argument
would be False. This table/range is probably where you are getting the
validation list from anyway.

--
Regards,
Tom Ogilvy

Okay, I have created a data-validation for a list of items, however, i

need the list, so that whatever item you pick from the list produces a price
into the adjacent cell? Can anyone help???