hello everybody. I have a question: is it possible to have excel to look up
more cells (i.e. =vlookup(sheet1!$A$1and$C$1,sheet2!$A$1:$C$3) and if both
values are equal then multiply what's in cell sheet2! by another cell in
sheet1!?

You can use MATCH and INDEX in that way

=INDEX(Sheet2!$D$1:$D$20,MATCH(Sheet1!$A$1&Sheet1! $C$1,Sheet2!$A$1:$A$20&She
et2!$C$1:$C$20,0))

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

The MATCH uses the concatenated values to lookup into tow concatentaed
ranges, which returns ajn index in the range(s). This is passed to INDEX to
get the actual corresponding value in Column D.

--

HTH

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


"antonov" wrote in message
...
hello everybody. I have a question: is it possible to have excel to look
up
more cells (i.e. =vlookup(sheet1!$A$1and$C$1,sheet2!$A$1:$C$3) and if both
values are equal then multiply what's in cell sheet2! by another cell in
sheet1!?

Hello Bob, thanks for the prompt reply... and what about the calculation? is
it possible?
"Bob Phillips" wrote in message
...
You can use MATCH and INDEX in that way

=INDEX(Sheet2!$D$1:$D$20,MATCH(Sheet1!$A$1&Sheet1! $C$1,Sheet2!$A$1:$A$20&She
et2!$C$1:$C$20,0))

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

The MATCH uses the concatenated values to lookup into tow concatentaed
ranges, which returns ajn index in the range(s). This is passed to INDEX
to
get the actual corresponding value in Column D.

--

HTH

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


"antonov" wrote in message
...
hello everybody. I have a question: is it possible to have excel to look
up
more cells (i.e. =vlookup(sheet1!$A$1and$C$1,sheet2!$A$1:$C$3) and if
both
values are equal then multiply what's in cell sheet2! by another cell in
sheet1!?

Antonov,

That gets the value so just add *other_cell_ref on the end.

--

HTH

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


"antonov" wrote in message
...
Hello Bob, thanks for the prompt reply... and what about the calculation?
is
it possible?
"Bob Phillips" wrote in message
...
You can use MATCH and INDEX in that way


=INDEX(Sheet2!$D$1:$D$20,MATCH(Sheet1!$A$1&Sheet1! $C$1,Sheet2!$A$1:$A$20&She
et2!$C$1:$C$20,0))

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

The MATCH uses the concatenated values to lookup into tow concatentaed
ranges, which returns ajn index in the range(s). This is passed to INDEX
to
get the actual corresponding value in Column D.

--

HTH

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


"antonov" wrote in message
...
hello everybody. I have a question: is it possible to have excel to
look
up
more cells (i.e. =vlookup(sheet1!$A$1and$C$1,sheet2!$A$1:$C$3) and if
both
values are equal then multiply what's in cell sheet2! by another cell
in
sheet1!?

Thanks Bob... I will try it tomorrow at the office... will let you know....

"Bob Phillips" wrote in message
...
Antonov,

That gets the value so just add *other_cell_ref on the end.

--

HTH

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


"antonov" wrote in message
...
Hello Bob, thanks for the prompt reply... and what about the calculation?
is
it possible?
"Bob Phillips" wrote in message
...
You can use MATCH and INDEX in that way


=INDEX(Sheet2!$D$1:$D$20,MATCH(Sheet1!$A$1&Sheet1! $C$1,Sheet2!$A$1:$A$20&She
et2!$C$1:$C$20,0))

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

The MATCH uses the concatenated values to lookup into tow concatentaed
ranges, which returns ajn index in the range(s). This is passed to
INDEX
to
get the actual corresponding value in Column D.

--

HTH

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


"antonov" wrote in message
...
hello everybody. I have a question: is it possible to have excel to
look
up
more cells (i.e. =vlookup(sheet1!$A$1and$C$1,sheet2!$A$1:$C$3) and if
both
values are equal then multiply what's in cell sheet2! by another cell
in
sheet1!?

Bob.... ehmmm... I think I am doing something wrong....as all I get if I
apply the formula is "#N/A"... The formula has to go in cell J7. The match
has to be between A1&I1 and sheet2!A1:A4&B1:B4. Now: the table in Sheet2 is
as follows:
(A1) CI (B1) VE (C1) 0.004
(A2) CI (B2) MI (C2) 0.003
so... say the result of the match is CI VE then I need the data in cell
Sheet1!G1 to be multiplied by Sheet2!C1.... do you think it is possible?
thanks again for your patience


"antonov" wrote in message
...
Thanks Bob... I will try it tomorrow at the office... will let you
know....

"Bob Phillips" wrote in message
...
Antonov,

That gets the value so just add *other_cell_ref on the end.

--

HTH

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


"antonov" wrote in message
...
Hello Bob, thanks for the prompt reply... and what about the
calculation?
is
it possible?
"Bob Phillips" wrote in message
...
You can use MATCH and INDEX in that way


=INDEX(Sheet2!$D$1:$D$20,MATCH(Sheet1!$A$1&Sheet1! $C$1,Sheet2!$A$1:$A$20&She
et2!$C$1:$C$20,0))

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

The MATCH uses the concatenated values to lookup into tow concatentaed
ranges, which returns ajn index in the range(s). This is passed to
INDEX
to
get the actual corresponding value in Column D.

--

HTH

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


"antonov" wrote in message
...
hello everybody. I have a question: is it possible to have excel to
look
up
more cells (i.e. =vlookup(sheet1!$A$1and$C$1,sheet2!$A$1:$C$3) and if
both
values are equal then multiply what's in cell sheet2! by another cell
in
sheet1!?