I have a list of fund names in Column A. I also have currencies for these in column B. Some fund names may exist more than once but using different currencies.
I need a formula in column C which will populate data from sheet 'Master Data' based on the fund name AND currency.
So far I can only get it to look up based on the fund name, and not the currency also.
This is the formula I am currently using:
=IF(A2="","",VLOOKUP($A2,'Master Data'!$A:$F,2,FALSE))
Bookmarks