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?