I am working on a case that is of the following similar natu

Col A Col B Col C
Row 1 Apple 1 ABC
Row 2 Bananna 2 DEF
Row 3 Cherry 1 GHI
Row 4 Cherry 4 JKL
Row 5 Cherry 6 MNO
Row 6 Strawberry 3 PQR

I want to lookup the value in Col C that has "Cherry" in Col A and "6" in
'Col C'. Ofcourse the answer is "MNO", but I am unable to accomplish this
with VLOOKUP. Is there any alternative solution to this.

Thanks,
Rafat Inayat Elahi