How do I find a cross reference value
 

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

Hi
try something like
=INDEX(A1:G20,MATCH(row_lookup_value,A1:A20,0),MAT CH(colummn_lookup_value,A1:G1,0))

"Jo Davis" wrote:

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

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

--
Don Guillett
SalesAid Software

"Jo Davis" <Jo wrote in message
...
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