using Vlookup to lookup a value in a matrix.. ????
 

Hello,

I hope someone can help me out with a problem am trying to solve..
ok here it is.

so i have a matrix:
a b c d e
1 qw qe qr qt qy
2 as ad af ag ah
3 zx zc zv zb zn
4 df dg dh dj dk
5 er et ey eu ei

I have two drop down menues that lets the user select a number (1-5) and a
letter (a-e), so if someone selects a "1" and a "b" the solutions should be
"qe" and so on... how can i do this, with vlookup or something else?
hopefully without any VBA but if i must then i will.

Thank you in advance.
TG

using Vlookup to lookup a value in a matrix.. ????
 

See http://www.contextures.com/xlFunctio...ml#IndexMatch3 for a solution

"TG" wrote:

Hello,

I hope someone can help me out with a problem am trying to solve..
ok here it is.

so i have a matrix:
a b c d e
1 qw qe qr qt qy
2 as ad af ag ah
3 zx zc zv zb zn
4 df dg dh dj dk
5 er et ey eu ei

I have two drop down menues that lets the user select a number (1-5) and a
letter (a-e), so if someone selects a "1" and a "b" the solutions should be
"qe" and so on... how can i do this, with vlookup or something else?
hopefully without any VBA but if i must then i will.

Thank you in advance.
TG

using Vlookup to lookup a value in a matrix.. ????
 

Try this:

Assume your table is in the range A1:F6

A10 = drop down menu for the row number
B10 = drop down menu for the column letter

=VLOOKUP(A10,A1:F6,MATCH(B10,A1:F1,0),0)

--
Biff
Microsoft Excel MVP


"TG" wrote in message
...
Hello,

I hope someone can help me out with a problem am trying to solve..
ok here it is.

so i have a matrix:
a b c d e
1 qw qe qr qt qy
2 as ad af ag ah
3 zx zc zv zb zn
4 df dg dh dj dk
5 er et ey eu ei

I have two drop down menues that lets the user select a number (1-5) and a
letter (a-e), so if someone selects a "1" and a "b" the solutions should
be
"qe" and so on... how can i do this, with vlookup or something else?
hopefully without any VBA but if i must then i will.

Thank you in advance.
TG