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.
|