Lookup based on two criteria

  • Thread starter Thread starter GK80535
  • Start date Start date
G

GK80535

I have a table in excel. I have company names going down a column an
time periods going across the rows. Is there a function I can use tha
returns the value for a particular company at a particular time period?

Basically, I need the data point at the intersection of the compan
name and the time period.

Can anybody help? Is this possible in Excel
 
Hi
use something like
=INDEX(A1:G20,MATCH("company",A1:A20,0),MATCH(value,A1:G1,0))
 
You must log in or register to reply here.

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

Stacked Columns (two separate companies, 3 time periods) 1
Can this be done with Excel ? 2
Excel "remembering" sort criteria 3
Lookup help 5
Would I use LOOKUP for this? 2
Counting Down to a Blank Row 6
Lookup date range row A and count if leave in same column on row B 6
Lookup Function for Excel 2007 2

Back
Top