View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
David P. David P. is offline
external usenet poster
 
Posts: 67
Default Match word in one column to another

I need a formula to output in column C the closest match in column B from
column A:

Column A Coumn B Column C
"I ate apples" "Orange" Formula to output "Apple" as a
closest match
"I ate oranges" "Pear"
"I ate pears" "Apple"

I know this is probably elementary but thank you for the help.
--
David P.