Looking up data within a table
 

I have a data table where user input will automatically output both the row
and column matches, and I would like to utilize a lookup function that will
read across that column and down that row to give me an automatic output.
VLOOKUP and HLOOKUP do not seem to be working. Can anyone help?

Looking up data within a table
 

Follow this general syntax:

B1:F1 = column headers
A2:A10 = row headers
B2:F10 = actual data table

X1 = input row header
X2 = input column header

=INDEX(B2:F10,MATCH(X1,A2:A10,0),MATCH(X2,B1:F1,0) )

--
Biff
Microsoft Excel MVP


"MikeD VP" <MikeD wrote in message
...
I have a data table where user input will automatically output both the row
and column matches, and I would like to utilize a lookup function that
will
read across that column and down that row to give me an automatic output.
VLOOKUP and HLOOKUP do not seem to be working. Can anyone help?