Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Matrix lookup/mulitple criteria lookup | Excel Discussion (Misc queries) | |||
Matrix Lookup | Excel Discussion (Misc queries) | |||
lookup in MATRIX | Excel Worksheet Functions | |||
Number Lookup in Matrix | Excel Worksheet Functions | |||
Lookup in Matrix | Excel Worksheet Functions |