| Home |
| Search |
| Today's Posts |
|
#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, |
| 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 | |||
Threaded Mode
