Using cells to hold the lookup criteria...

A1 = some ID number
B1 = some document type
C1 = some date

Then, array entered** :

=INDEX(Comments,MATCH(1,IF(ID=A1,IF(Document=B1,IF (DATE=C1,1))),0))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.

--
Biff
Microsoft Excel MVP


"AHK" wrote in message
...
ID # Document Date Comments
123456 Profile Statement 12/31/2009 Will be returned this week

Can someone help with a match formula that will match ID#, Document, and
Date (needs to match all three) and generate the text listed the comments
column. Thank you in advance!