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 |
#2
|
|||
|
|||
Actually you have the ideal setup to use a natural
language formula. Simply use: =2001 CA Staff and the formula will return 8. One important note - go to Tools Options Calculation tab and make sure the "Accept labels in formula" box is checked. Otherwise the formula will return an error. Natural language formulas do have several restrictions, but IMO are very useful. To learn more, see: HOW TO: Use Natural Language Formulas in Excel 2000 http://support.microsoft.com/?kbid=279412 HTH Jason Atlanta, GA -----Original Message----- 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 . |
Reply |
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 |