How to lookup data in a row and column

[Confused]

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.

[Chip Pearson]

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" <[email protected]> wrote in message
news:[email protected]...
>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.