Try this array formula** :

=INDEX(C23:C25,MATCH(1,(A23:A25=B27)*(B23:B25=B28) ,0))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

--
Biff
Microsoft Excel MVP


"Squid" wrote in message
...
I need a way to lookup a field based upon 2 items. I am stumped on how to
accomplish this. VLookup requires only 1 criteria. I tried creating an
array
formula {=VLOOKUP(B27:B28,A23:C25,3)}. It resulted in contract c, but if
i
change the criteria data to 1/1/09... the result did not change. Below is
an
example.

Table:
10000 1/1/2008 contract a
30000 1/1/2009 contract b
30000 1/1/2010 contract c

Criteria:
contract# 30000
date 1/1/2010

Result --- contract c