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 column C of my multiple other sheets. These have a name range of 'Sheets' . This has to be based on both the fund name AND the currency though?

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:
=IFERROR(VLOOKUP(A1,INDIRECT(INDEX(Sheets,MATCH(1,COUNTIF(INDIRECT(Sheets),A1),0))),3,0),"N/A")

Is anyone able to help me with this? :/