The most common way to do this is to create a helper column which
concatenates Description and CPT.

Then you can use Vlookup on this results to get the Category.

Regards,
Fred.

wrote in message
...
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,