lookup (v,h,index,match)

B

briank

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
 
J

Jason Morin

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Return Column Header from an Index/array, finding Large with a userinput date 0
lookup second / last match with two conditions 1
Specified formula cannot be entered bc it uses more than 64 levels of nesting. 3
Median If in Excel not working 4
INDEX MATCH SMALL 13
Index Match 4
re done Match formula needed 3
change column to rows with a match 3

Top