Can an expert assist me with this lookup please.
I need to look up 'A' and 'B' on sheet 2 and return 'C' from sheet 1 [range is Data]
I have shown in the attached spreadsheet what the results should be for the first 3, i.e.
A GBP XYZ
B EUR XYZ
C CAD ABC