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