Looking up data within a table

M

MikeD VP

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?
 
T

T. Valko

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))
 
Top