Hi everyone,

I have 4 price lists - they all have the same products and codes but are in different currencies. I would like to consolidate these into one and then display the correct price based on Data Validation drop down containing GBP, USD, Euro and RAND. Cell G2 (also named as Currency_Selected)

I have a table [Prices] in one sheet with product code, name and then 4 columns with price in each currency. On the second sheet I have already worked out to create a data validation drop list using the Product_Code - then using VLOOKUP I have populated the name and price in GBP (column 5) =VLOOKUP($A16,Prices,5,FALSE). I am assuming I need to somehow use and IF command to also bring in the Currency_Selected in order to to select the another column eg column 5 for USD.

I have tried some nested IF statements but just cant seem to get it working. Any advice appreciated - even a different approach.

Thanks.