Mutiple Condition Lookup

[wsadoo]

I am trying to write a statement that will return values in cells Q3, R
and S3 that will reference Columns A, C, and E in order to return th
values from Rows N, O, and P so that the Streak values are returned fo
the same game from the same week. I've tried nesting formulas i
VLOOKUPS and INDEX/MATCH combinations, but have obviously had littl
success.

My thanks in advance,
Bil

Attachment filename: nfl_1985_2003sample.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=65101

 

[Frank Kabel]

Hi
try something like the following array formula (entered with
CTRL+SHIFT+ENTER):
=INDEX(N1:N100,MATCH(1,(A1:A100=Q3)*(C1:C100=R3)*(E1:E100=S3),0))