I am in search of formula
 

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

I am in search of formula
 

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

I am in search of formula
 

Please don't multipost.
http://www.cs.tut.fi/~jkorpela/usenet/xpost.html
--
David Biddulph

"kakolisarkar" wrote in message
...
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

I am in search of formula
 

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