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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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???
 
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

Nat said:
Okay, I have created a data-validation for a list of items, however, i
Click to expand...
need the list, so that whatever item you pick from the list produces a price
into the adjacent cell? Can anyone help???
 
Back
Top