Hi,

Here is one of many ways

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

This is an array entered formula so you need to press Shift+Ctrl+Enter to
enter it, not Enter.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"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