Data Validation and Value

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

Guest

Hi,

Okay, I am trying to create a drop-down price list, so that if you pick an Item then in the in the next cell the price for that item appears, can anyone help???

Also, I have created this list, however I did it on a separate sheet and need to transfer it to another sheet but it won't paste properly and also on the sheet it was created, all the items show in the cells not as a list?

Thanks!
Nat
 
Assuming you have the validation going already, make a 2 dimensional table
with item and its price in an adjacent cell and use vlookup
in the cell where you want the price, cell A1 is the cell with the dropdown

=IF(A1="","",VLOOKUP(A1,Sheet1!$A$1:$B$100,2,0))

--

Regards,

Peo Sjoblom

Nat said:
Hi,

Okay, I am trying to create a drop-down price list, so that if you pick an
Click to expand...
Item then in the in the next cell the price for that item appears, can
anyone help???
Also, I have created this list, however I did it on a separate sheet and
Click to expand...
need to transfer it to another sheet but it won't paste properly and also on
the sheet it was created, all the items show in the cells not as a list?
 
Back
Top