Hi,

A general formula for a table lookup would be this

=INDEX(A1:E20, MATCH(F1,A1:A20,0), MATCH(G1,A1:E1,0))

Where
A1:E20 is the entire table including row and column headers
F1 is the value to match in the column
G1 is the value to match in the row

The intersect of the 2 is returned
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"jj023" wrote:

I am trying to have a worksheet locate a single data value based on two,
variable input values. The single data value is located at the intersection
of two variables in tables within the workbook. LOOKUP functions are only
good for one variable and column/row identifier. Since I have two variable
inputs, this won't work. Any ideas would be extremely helpful. Thanks.