How do I find a cross reference value

J

Jo Davis

I am trying to lookup data within a spreadsheet using cross references, for
example look down column B and across row 3 to find the value in the cross
refrenced cell. I have tried to adopt the LOOKUP function to no avail.

Any help would be great, i'm sure it's just a really straight forward formula

Many thanks
 
F

Frank Kabel

Hi
try something lik
=INDEX(A1:G20,MATCH(row_lookup_value,A1:A20,0),MATCH(colummn_lookup_value,A1:G1,0))
 
D

Don Guillett

try using MATCH to find the row and then OFFSET or INDEX to complete the
formula
 
Top