See the Double Lookups function at
http://www.cpearson.com/excel/lookups.htm .
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Confused" wrote in message
...
I have a chart in excel that shows salaries based on two
criteria. You go
down the column to find the first criteria, then across that
row for the
second (much like a mileage chart). How can I get excel to
lookup this
information? I only know how to use lookup to find data based
on one cell
location.