Match criteria in two columns and give a third colums result

[jd64361]

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,

 

[Fred Smith]

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.

 

[jd64361]

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:

 

[jd64361]

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.








- Show quoted text -

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

 

[Fred Smith]

Check your other post(s).

Regards,
Fred.

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: