Dear Sir,

I have two tables or blocks.

Price Nos
a b c d d e f a c b
5 6 7 8 6 2 1 6 3 4
2 5 4 9 7 8 9 5 2 3

a 40
b 39
c 29
d 111

I want a formula which will search for "a" in block "Price and also in block
"Nos" and then sumproduct the said column and give result such as "a" - 40,
"b"-39 etc.

Nimish