Nimish
You can try this simple formula
C10 = SUMPRODUCT(--($A$2:$A$7=A10)*--($B$2:$B$7=B10),C2:C7)
A10 = Tom
B10 = Apple
a2:a7 = farmer names
b2:b7 = product names
c2 : c7 = price
With regards
Sridhar
"Nimish Shah" wrote:

Hi Sridhar,

I have tried the formula but not working, showing as #N/A.
I could not understand: match("cost",$a$1:$c$1,)).
I have never used the ARRAY formula.

Please help.

Regards,

Nimish






"yshridhar" wrote:

Hi Nimish
Say if your data table is in A1:C7;
Try it in C9
C9 =INDEX($A$1:$C$7, MATCH(1,(($A$1:$A$7=A9)*($B$1:$B$7=B9)),0),
MATCH("Cost",$A$1:$C$1,))
it is an array formula. you have to use ctrl+shift+enter not just enter
A9= Name
B9 = Product
with regards
Sridhar


"Nimish Shah" wrote:

Dear Sir,

I am in search of a formula to fill up the cells of "Price per each" column ?

Data Available
Farmer Product Price Per Each Farmer Product Price Per Each

Tom Apple Tom Apple 10
Harry Apple Tom Mango 15
Harry Banana Tom Banana 5
Tom Apple Harry Apple 20
Harry Mango Harry Mango 30
Harry Apple Harry Banana 7
Tom Mango
Harry Mango
Tom Banana
Tom Mango
Tom Banana
Tom Apple
Harry Apple
Tom Mango

Regards,

Nimish