Confused wrote:
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.
If you use row and column headers (first criteria and second criteria)
that are valid range names, then highlight your data range, including
the headers, click on Insert|Name|Create and check Top row and Left
column, then OK, you can use the "Intersection Operator", i.e., the
space. E.g.:

CriterionC1 CriterionC2 CriterionC3
CriterionR1 $1 $2 $3
CriterionR2 $4 $5 $6
CriterionR3 $7 $8 $9

=CriterionC2 CriterionR3 will return $9
=CriterionR3 CriterionC2 will return $5, etc.

Or, as has been suggested (though I don't understand the comment about
incrementing the MATCH function by 1), with the first criterion in Cell
E1 and the second in Cell F1

=VLOOKUP(E1,A1:D4,MATCH(F1,A1:D4,0))

Alan Beban