How to lookup data in a row and column
 

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.

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.