View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Nimish Shah Nimish Shah is offline
external usenet poster
 
Posts: 20
Default Search of a Formula/Function

Dear Sir,

I am in seacrh of a formula. I want to fill up the cell of COST-TOm and
COST-Harry.

Product COST-TOM COST-Harry
Apple ??? ???
Mango ??? ???
Banana ??? ???

Data Available
Farmer Product COST
Tom Apple 10
Harry Apple 20
Harry Banana 7
Tom Apple 10
Harry Mango 30
Harry Apple 20
Tom Mango 15
Harry Mango 30

Regards,
Nimish