You can use this kind of syntax:

=index(othersheet!$c$1:$c$100,
match(1,(a2=othersheet!$a$1:$a$100)*(b2=othersheet !$b$1:$b$100),0))
(one cell)

This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)

Adjust the range to match--but you can't use the whole column.

Kasper wrote:

I am trying to extract data from a spreadsheet using a search function that
has two search criteria. For example, I have a worksheet filled with
employee performance data and need to extract data to a table based employee
name AND date. Something similar to VLOOKUP but with two filters instead of
one.

--

Dave Peterson