How do you cross reference different speadsheets?

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

Guest

I wanted to know how to cross reference 2 different speadsheets to look for
similar or matching information.
 
basically the formual would look like ='[workbook name.xls]spredsheet'!then
the on the sheet you are looking for with $in front of the letter and $in
front of the number

i.e. ='[Test 2006 Report .xls]Test 1'!$A$42
 
Hi Chip,
My guess is that you want to use VLOOKUP Worksheet Function\
http://www.mvps.org/dmcritchie/excel/vlookup.htm
and since your name is Chip perhaps also
Lookups (Chip Pearson)
http://www.cpearson.com/excel/lookups.htm#ClosestMatch


chip_pyp said:
basically the formual would look like ='[workbook name.xls]spredsheet'!then
the on the sheet you are looking for with $in front of the letter and $in
front of the number

i.e. ='[Test 2006 Report .xls]Test 1'!$A$42

Shae said:
I wanted to know how to cross reference 2 different speadsheets to look for
similar or matching information.
Click to expand...
Click to expand...
 
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

Conditional Formatting 3
Excel spreadsheet linking 1
updateing a orginal sheet after two or more have updated copys 1
Extracting partial information from a cell 2
Excel Sum numbers in cells that also contain text 34
Format a macro button 2
How do I make info. from one cell auto. feed in to another cell? 1
how can i view 2 spreadsheets on an extended desktop 1

Back
Top