| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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, |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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: |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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??? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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: |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count if two columns match different criteria | Excel Worksheet Functions | |||
| Search and match two colums give third column result | Excel Discussion (Misc queries) | |||
| Provide a match from 2 cells to give a result from another | Excel Worksheet Functions | |||
| How do I give different $ value to different colums in Excel? | Excel Worksheet Functions | |||
| how can I have a formula result based on multiple criteria/columns | New Users to Excel | |||
Linear Mode
