Home |
Search |
Today's Posts |
#1
|
|||
|
|||
simultaneous v&h lookup - approaches...
AFAIK, Excel has no function allowing simultaneous search for 1 value
along leftmost column of a table range and then also search horizontally across table top row. 1 way to do this is to embed a LOOKUP to figure out how many columns or rows to index over (in case of VLOOKUP/HLOOKUP respectively). Anything else? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create a lookup table with an added varable? | Excel Worksheet Functions | |||
Lookup Problem | Excel Worksheet Functions | |||
Index table lookup anomaly | Excel Worksheet Functions | |||
Excel Lookup Functions | Excel Worksheet Functions | |||
double lookup, nest, or macro? | Excel Worksheet Functions |