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

Pivot Table Data Aggregation 0
Large Data File Consolidation... 2
VLOOKUP/HLOOKUP Query 0
Refer to current row in formula 5
Counting multiple occcurrences between date range 3
Hlookup/Vlookup with duplicate datas 0
looking up cell address 1
Can users perform a reverse lookup 7

Top