Non-numeric row/column ordinal value for array

[lsgexel]

I have the Excel sheet with rows: 1,2,3 and cols A, B, C, D:
--------------------------------------------
A B C D
--------------------------------------------
1 N M Y R
2 E .5 .7 .9
3 S .6 .4 .3
--------------------------------------------
I would like to use non-numeric values for rows (N, M, Y, R) and columns (E,S) to index the table as follows:

=Index(B2:D3,R,2)
should return the value .9

How can this be done?

 

[Ron Coderre]

I think you'd need to use something like this:
=INDEX(B1:D3,2,MATCH("R",B1:D1,0))

Is that something you can work with?

 

[T. Valko]

Duplicate post?

http://www.mrexcel.com/forum/showthread.php?t=576443

 

[Ron Coderre]

Duplicate post?

http://www.mrexcel.com/forum/showthread.php?t=576443

I was just thinking the same thing as I read the other post.

 

[lsgexel]

Works great Ron. Thanks.