Match criteria in two columns and give a third colums result

  • Thread starter Thread starter jd64361
  • Start date Start date
J

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,
 
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.
 
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,
Click to expand...

I forgot to add that this is my table were I am trying to find the
data that is located in a different column:
 
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 -
Click to expand...

I don't want a Helper column looking more into a index match formula
anyone???
 
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,
Click to expand...

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Search and match two colums give third column result 3
Match two criterias and give a third colums result 7
Help with INDEX/MATCH 2
VLOOKUP MATCH INDEX two conditions / criterias text and date 7
Using INDEX and MATCH to find data in 2 different sheets 5
locating all instances of text in a column 5
Sorting and Matching criteria across rows to return a result in the last cell 7
Custom function to find top sellers 2

Back
Top