Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
is it possible to make a lookup_reference and lookup result directly from a
non-adjacent cells,, maybe something like this... =LOOKUP(A1,{U1:V1&","&X1:Y1&","&AA1:AB1},{I1:J1&", "&L1:M1&","&O1:P1}) like if the value on A1 is exactly equal to a value on either U1 or V1, then RESULT will be from L1 or M1, and if not found, it will search again on the next... if not possible, please advice thanks and more power driller |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
A question for Match and Lookup | Excel Discussion (Misc queries) | |||
Lookup problem | Excel Worksheet Functions | |||
Another way to lookup data | Excel Worksheet Functions | |||
Lookup function help | Excel Worksheet Functions | |||
Lookup and Sort Question | Excel Discussion (Misc queries) |