Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match two criterias 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.worksheet.functions
|
|||
|
|||
Match two criterias and give a third colums result
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, |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match two criterias and give a third colums result
Anyone else have a beter idea without combining cell?????
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match two criterias and give a third colums result
What would the criteria be for "better"?
-- Kind regards, Niek Otten Microsoft MVP - Excel wrote in message ... Anyone else have a beter idea without combining cell????? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match two criterias and give a third colums result
On Nov 18, 2:31*pm, "Niek Otten" wrote:
What would the criteria be for "better"? -- Kind regards, Niek Otten Microsoft MVP - Excel wrote in message ... Anyone else have a beter idea without combining cell?????- Hide quoted text - - Show quoted text - Better means how about a Match to criteria and give the result of the third column where column one and column two matches!!! thank you!!! Pantera |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match two criterias and give a third colums result
On Nov 18, 2:31*pm, "Niek Otten" wrote:
What would the criteria be for "better"? -- Kind regards, Niek Otten Microsoft MVP - Excel wrote in message ... Anyone else have a beter idea without combining cell?????- Hide quoted text - - Show quoted text - A index Match formula where the criteria from F5 is found in column description and criteria two from E5 is found in column CPT giving the result whe both criterias are match from column catergory!!! thank you, |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match two criterias and give a third colums result
On Nov 18, 2:31*pm, "Niek Otten" wrote:
What would the criteria be for "better"? -- Kind regards, Niek Otten Microsoft MVP - Excel wrote in message ... Anyone else have a beter idea without combining cell?????- Hide quoted text - - Show quoted text - ANSWER FOUND THANK YOU!!!!!!!!!!!! |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match two criterias and give a third colums result
Try this array formula** :
E2 = lookup description F2 = lookup CPT =INDEX(C2:C7,MATCH(1,(A2:A7=E2)*(B2:B7=F2),0)) ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER) -- Biff Microsoft Excel MVP 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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match criteria in two columns and give a third colums result | Excel Discussion (Misc queries) | |||
Search and match two colums give third column result | Excel Discussion (Misc queries) | |||
VLOOKUP MATCH INDEX two conditions / criterias text and date | Excel Worksheet Functions | |||
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 |