=INDEX(C2:C10,MATCH(1,(A2:A10=1)*(B2:B10=5),0))

entered with ctrl + shift & enter

--


Regards,


Peo Sjoblom

"NatashaS" wrote in message
...
Hi,

I wondered if there is a function in Excel that allows you to look up a
value by two or more columns. (e.g. I want to ask for "column 1 = 1" AND
"column 2 = 5" to get the result "pears".

Column 1 Column 2 Column 3
1 5 apples
1 10 oranges
3 5 pears