How do I find a cross reference value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 lik
=INDEX(A1:G20,MATCH(row_lookup_value,A1:A20,0),MATCH(colummn_lookup_value,A1:G1,0))
 
try using MATCH to find the row and then OFFSET or INDEX to complete the
formula
 
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

Cross reference 1
Return cell reference instead of value 1
How to reference a null value? ie: =Lookup("", B2:B4, A2:A4) 6
Need Help with Substitute Formulas, etc. 5
Look up a reference which has more than 1 exact match 1
Trying to set up a cross reference chart, best way to copy formulas? 2
Cross Referencing between worksheets 1
Cell/Range references and Microsift Query 2

Back
Top