Dear Mangesh,
Thanks for yr help. it works.
may i know how this sumproduct uses for? i do not understand. what about the
match and index function?
rgds
"mangesh_yadav" wrote:
Lets say your table is in the range A10:C15 (the table which you have
given below). And lets say the two example (list) is in the first 2
rows starting A1.
To get the rate, use the following formula:
=SUMPRODUCT(--($A$10:$A$15=A1),--($B$10:$B$15=B1),$C$10:$C$15)
and copy down.
where A1 has the month, B1 the currency
Mangesh
--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=378013