Data Validation and Value

[Nat]

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

 

[Peo Sjoblom]

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

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?