Chip Pearson has a good article on understanding array formulas for future
reference.

http://www.cpearson.com/excel/ArrayFormulas.aspx

Try:
(Where D1 and D2 are your criteria cells)
=INDEX($A$23:$C$25,MATCH($D$1&$D$2,$A$23:$A$25&$B$ 23:$B$25,0),3)

Entered as an array with ctrl+shift+enter

Does that do what you're looking for?


"Squid" wrote:

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