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