Hey everyone, Im having a bit of a problem with excel and drop down lists.
I have a list on excel of say product a, b and c and in the cell to the right of them their prices so I have products in cells A1, A2 and A3 and prices in B1, B2 and B3.
I have created a drop down list in cell A5 and I want cell B5 to have the correct price for what ever is selected in the drop down list.
I have tried using an IF for example:
=IF(A5=A1,B1)(A5=A2,B2) but I cant seem to find a way to get it to work.
any tips?
Cheers,
Tom
Bookmarks