Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
concantenate then index match
Hi.
Is it possible to concantenate one cell with text with another cell with a number in it and take that result and then use it in an index/match formula to find a result? Or will it not work? It looks like this: C1 D1 E1 2 3 A C3 D3 E3 F3 A 2 3 1 H H H 2 S S S A3 D D D Now, Concantenate D1 & E1, then use the Index Match with cell C1 to find a result of D in cells D4 through F7. Hope I explained my question properly. Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
concantenate then index match
Hope I explained my question properly.
Well, your description isn't real clear but what you want to do can be done. C1 D1 E1 2 3 A Now, Concantenate D1 & E1 Ok, concantenated D1 & E1 = 3A then use the Index Match with cell C1 Ok, C1 = 2. What is the significance of 2 as it relates to what you want to do? So, we have 2 and 3A, now what? -- Biff Microsoft Excel MVP "Robb27" wrote in message ... Hi. Is it possible to concantenate one cell with text with another cell with a number in it and take that result and then use it in an index/match formula to find a result? Or will it not work? It looks like this: C1 D1 E1 2 3 A C3 D3 E3 F3 A 2 3 1 H H H 2 S S S A3 D D D Now, Concantenate D1 & E1, then use the Index Match with cell C1 to find a result of D in cells D4 through F7. Hope I explained my question properly. Thanks. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
concantenate then index match
Hi,
Try this =index(C3:D7,match(E1&D1,C3:C7,0),match(C1,C3:F3,0 )) -- Regards, Ashish Mathur Microsoft Excel MVP "Robb27" wrote in message ... Hi. Is it possible to concantenate one cell with text with another cell with a number in it and take that result and then use it in an index/match formula to find a result? Or will it not work? It looks like this: C1 D1 E1 2 3 A C3 D3 E3 F3 A 2 3 1 H H H 2 S S S A3 D D D Now, Concantenate D1 & E1, then use the Index Match with cell C1 to find a result of D in cells D4 through F7. Hope I explained my question properly. Thanks. |
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 |