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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

looking up cell address 1
Lookup data in a variable table & retrieve data from a pivot table 3
Large Data File Consolidation... 2
Can users perform a reverse lookup 7
How do I look up which column a value is in? 7
hlookup value within a range 4
looking up values from a table 2
Vlookup & hlookup 3

Top