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!

=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!

This didnt work. I am not sure how to expalin what I need. I am fairly new to
as advanced of work in excel as this. I also noticed that what I had earlier
was written wrong, but either way neither formulas worked. I adjusted the
formula you offered and it still gave the error.

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

Breakdown:
IF('Report Data'!F7:F65536=1) - this is the first range of data needing to
be reviewed

('Report Data'!R7:R65536=QL) - this is the second range

SUM('Report Data'!I1:I65536) - This should be the outcome. Summing what
matches with the two listed ranges above.



"Bob Phillips" wrote:

=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!

=SUMPRODUCT(--('Report Data'!F7:F65535=1),
--('Report Data'!R7:R65535="QL"),I1:I65535)

--
HTH

Bob Phillips

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

"chelles" wrote in message
...
This didnt work. I am not sure how to expalin what I need. I am fairly new
to
as advanced of work in excel as this. I also noticed that what I had
earlier
was written wrong, but either way neither formulas worked. I adjusted the
formula you offered and it still gave the error.

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

Breakdown:
IF('Report Data'!F7:F65536=1) - this is the first range of data needing to
be reviewed

('Report Data'!R7:R65536=QL) - this is the second range

SUM('Report Data'!I1:I65536) - This should be the outcome. Summing what
matches with the two listed ranges above.



"Bob Phillips" wrote:

=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!

I got a value error on this as well.

"Bob Phillips" wrote:

=SUMPRODUCT(--('Report Data'!F7:F65535=1),
--('Report Data'!R7:R65535="QL"),I1:I65535)

--
HTH

Bob Phillips

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

"chelles" wrote in message
...
This didnt work. I am not sure how to expalin what I need. I am fairly new
to
as advanced of work in excel as this. I also noticed that what I had
earlier
was written wrong, but either way neither formulas worked. I adjusted the
formula you offered and it still gave the error.

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

Breakdown:
IF('Report Data'!F7:F65536=1) - this is the first range of data needing to
be reviewed

('Report Data'!R7:R65536=QL) - this is the second range

SUM('Report Data'!I1:I65536) - This should be the outcome. Summing what
matches with the two listed ranges above.



"Bob Phillips" wrote:

=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!

All ranges *must* be the same size.

Start Column I range at row 7, to equal the other ranges!
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"chelles" wrote in message
...
I got a value error on this as well.

"Bob Phillips" wrote:

=SUMPRODUCT(--('Report Data'!F7:F65535=1),
--('Report Data'!R7:R65535="QL"),I1:I65535)

--
HTH

Bob Phillips

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

"chelles" wrote in message
...
This didnt work. I am not sure how to expalin what I need. I am fairly
new
to
as advanced of work in excel as this. I also noticed that what I had
earlier
was written wrong, but either way neither formulas worked. I adjusted
the
formula you offered and it still gave the error.

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

Breakdown:
IF('Report Data'!F7:F65536=1) - this is the first range of data needing
to
be reviewed

('Report Data'!R7:R65536=QL) - this is the second range

SUM('Report Data'!I1:I65536) - This should be the outcome. Summing what
matches with the two listed ranges above.



"Bob Phillips" wrote:

=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!

If the F7 = 1 and R7 = QL you want I1 to appear in the cell your formula is in?

=IF(AND(F7=1,R7="QL"),I1,"")

You would then copy the formula down if what I said in the 1st line is true

"chelles" wrote:

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!

This didnt work. I am not sure how to expalin what I need. I am fairly new to
as advanced of work in excel as this. I also noticed that what I had earlier
was written wrong, but either way neither formulas worked. I adjusted the
formula you offered and it still gave the error.

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

Breakdown:
IF('Report Data'!F7:F65536=1) - this is the first range of data needing to
be reviewed

('Report Data'!R7:R65536=QL) - this is the second range

SUM('Report Data'!I1:I65536) - This should be the outcome. Summing what
matches with the two listed ranges above.



"tim m" wrote:

If the F7 = 1 and R7 = QL you want I1 to appear in the cell your formula is in?

=IF(AND(F7=1,R7="QL"),I1,"")

You would then copy the formula down if what I said in the 1st line is true

"chelles" wrote:

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!