If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
concantenate then index match
Hi,
Try this =index(C37,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. |
Thread Tools | |
Display Modes | |
|
|