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.