Thread: 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" <Confused@discussions.microsoft.com> wrote in message
news:70C4C894-8260-4409-AE16-05A2F5F4BF46@microsoft.com...
>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.