Hi,

I have to find the cell address of a data based on 2 criteria:

Data look as given below

FRUITS COUNTRY OF ORIGIN RATE/KG
Apple Newzealand 4
Kiwi Newzealand 7

Assume Headers are in ROW "1".


Now i want to find the CELL ADDRESS of Apple,based on B2,C2.

Eventually the result is A2.

How to do it? Any help is appreciated.

Thank you.