Looking up data within a table

  • Thread starter Thread starter MikeD VP
  • Start date Start date
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?
 
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

Large Data File Consolidation... 2
looking up cell address 1
Can users perform a reverse lookup 7
hlookup value within a range 4
using hlookup to reference a column in a vlookup formula? 3
colating data from a table - for bespoke report 4
Looking up data in a table 7
How do I look up which column a value is in? 7

Back
Top