View Single Post
  #1   Report Post  
briank
 
Posts: n/a
Default 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