concantenate then index match

R

Robb27

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

T. Valko

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top