I have two columns, “Item”, and “Price”. I have several predefined items and the price for the item respectively. Whenever I pick an item from the list for one cell, I want its price shown in the next cell.

If an item (for example “pencil”) is selected from the drop down list for the cell A2, I want the price of the pencil (for example “2”) automatically shown in the cell B2.

Can someone please show me how to do it? I tried the IF but I have a lot of predefined items, it is almost impossible to do it.

Thanks in advance.