Match criteria in two columns 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,

Match criteria in two columns and give a third colums result
 

JD, if you're going to repost your message, you're far better off to say you
need a solution that doesn't involve a helper column. Otherwise you're
likely to get the same response.

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,

Match criteria in two columns and give a third colums result
 

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:

Match criteria in two columns and give a third colums result
 

On Nov 18, 2:34*pm, "Fred Smith" wrote:
JD, if you're going to repost your message, you're far better off to say you
need a solution that doesn't involve a helper column. Otherwise you're
likely to get the same response.

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,- Hide quoted text -

- Show quoted text -

I don't want a Helper column looking more into a index match formula
anyone???

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: