Excel Drop Down

[philipad]

Hi all,
Some help for a newbie
I would like to have a value appeared in a cell according to a choice selected from a drop-down form and a pricelist in the same sheet.
If it's no trouble let me know how to do the same with the pricelist on othe sheet
Thanks a lot!

[philipad]

*other sheet

[Bob Phillips]

Just use VLOOKUP in B1

=VLOOKUP(A1,A19:B22,2,FALSE)

If th lookuptable is on another sheet, precede the range with the sheet name, e.g Sheet2!A1:B10