View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] jd64361@gmail.com is offline
external usenet poster
 
Posts: 18
Default Match two criterias and give a third colums result

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,