=IF(ISNA(MATCH(A2&B2,scores!A1:A100&scores!B1:B100 ,0)),"",IF(INDEX(scores!E1
:E100,MATCH(A2&B2,scores!A1:A100&scores!B1:B100,0) )INDEX(scores!C1:C100,MAT
CH(A2&B2,scores!A1:A100&scores!B1:B100,0)),"W","") )

which is an array formula so commit with Ctrl-Shift-Enter

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jambruins" wrote in message
...
I have a tab called games with the following info these are just two rows,
there are a hundred or so rows):
A B C D
1 ANH # W/L
2 Oct 16 WILD

I have another tab called scores with the following info (these are just
two
rows, there are a hundred or so rows):
A B C D E
1 Oct 16 TB 2 WAS 3
2 Oct 16 WILD 4 ANH 1

I would like cell D2 in the games tab to be a W if cell E2C2 in tab
scores.
How do I use a vlookup with two conditions? I need to lookup Oct 16 in
the
scores tab and WILD at the same time to return the 4 from cell C2. Thanks