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.

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.

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.