Home |
Search |
Today's Posts |
#1
|
|||
|
|||
lookup (v,h,index,match)
I would like to use a lookup command to search for data but am overwhelmed by
the various lookup choices and would like assistance. Ideally I want to search for a number based upon one vertical condition (i.e. staff) and two horizontal conditions (i.e. 2001 AND CA). For example, searching for Staff @ 2001 AND WA. Any suggestions? ---2001--- ---2004--- CA WA OH CA WA OH Staff 8 9 6 6 5 4 Insurance 6 7 3 5 0 7 Travel 5 4 9 9 8 4 |
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 |