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