=INDEX(I1:I65535,MATCH(1,('Report Data'!F7:F65535=1)*('Report
Data'!R7:R65535="QL"),0))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"chelles" wrote in message
...
I have two worksheets in one workbook. Both contain tables, one condenses
data from the other. I am needing to pull specific data from a column as
result of data in two other columns with the end result in the second
worksheet. Normally I would use the VLookup; however I have two ranges and
this is not possible. So far this is the formula I have come up with, yet
I
have not be able to make it work.

=IF('Report Data'!F7:F65536=1),('Report Data'!R7:R65536=QL), I1:I65536

PLEASE HELP!