View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default Match criteria in two columns and give a third colums result

Check your other post(s).

Regards,
Fred.

wrote in message
...
On Nov 18, 2:30 pm, wrote:
Hi everyone:
I have a three column I need a formula that matches decription and
CPT and if a match found to give the result from category.

Decription CPT Category
1. Exams 99201fp Blue
1. vision 99203O Orange
1. dental 99202n Black
1. Exams 99207p White
1. other 99206h Purple
1. Exams 99208c Red

Thank you,


I forgot to add that this is my table were I am trying to find the
data that is located in a different column: