When using a drop down to get it to reference another cell
Here you have use both validation and v lookup
For eg there in col A there is a item description and in col B there is the
price now you need to validate first col A and the table for the price of
those product should be ready some where on the same sheet far from the main
table.
col A(description) col B (price)
Table 10
Formula for vlook up will be
=VLOOKUP(A2,Q2:R6,2,FALSE)
now any one selecting from the drop down list will get the price accordingly
--
Thanks
Suleman Peerzade
"Josh" wrote:
How do I select a item in a drop down or Validation and get a price to show
up in another cell. I have 30 items in my drop down. So in column C it will
need to reference 30 prices along with those items. I think you can only
have 7 If then sceriario's. This is excell 2003
|