Lookup based on two criteria

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
 
F

Frank Kabel

Hi
use something like
=INDEX(A1:G20,MATCH("company",A1:A20,0),MATCH(value,A1:G1,0))
 
Top