Mike

Thank you for your response.

b= 69 is typing mistake it will be 28

kakoli

"Mike H" wrote:

Why does b=69, is that a typo?

"kakolisarkar" wrote:

Dear Sir,

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

a 41
b 69
c 91
d 46

I want a formula which will search "a" in block " Price per each" and in
"Nos" and then automatically sumproduct the said column and will give result
such as "41". Similarly "b"- 69, "c"-91, "d"-46.

Kakoli