| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
INDEX OR MATCH
I have a table like this:
ID Code Notes BOX549 a2 Drop BOX355 aA Drop BOX355 AA Add I am trying to find a formula for "Notes" Column of table below (note the Code has upper and lower cases) Code ID Notes a2 BOX549 Drop A3 BOX355 AA BOX355 Add aA BOX355 Drop Aa BOX355 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
INDEX OR MATCH
Hello carl,
If your first table is in A1:C4 and you have a code to lookup in E2 and an ID in F2 try this formula in G2 copied down =LOOKUP("zzzzz",CHOOSE({1,2},"",LOOKUP(2,1/(EXACT(E2,B$2:B$4)*EXACT (F2,A$2:A$4)),C$2:C$4))) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
INDEX OR MATCH
See your other post(s)
http://tinyurl.com/9rgcxx -- Biff Microsoft Excel MVP "carl" wrote in message ... I have a table like this: ID Code Notes BOX549 a2 Drop BOX355 aA Drop BOX355 AA Add I am trying to find a formula for "Notes" Column of table below (note the Code has upper and lower cases) Code ID Notes a2 BOX549 Drop A3 BOX355 AA BOX355 Add aA BOX355 Drop Aa BOX355 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find Exact Match using INDEX, MATCH | Excel Worksheet Functions | |||
| index(match) Wind Uplift Calculations (match four conditions) | Excel Worksheet Functions | |||
| index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
| How do I display more than one match in a Index/Match formula? | Excel Worksheet Functions | |||
| index,match,match on un-sorted data | Excel Worksheet Functions | |||
Hybrid Mode
