How do you cross reference different speadsheets?

S

Shae

I wanted to know how to cross reference 2 different speadsheets to look for
similar or matching information.
 
C

chip_pyp

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
 
D

David McRitchie

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
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

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...
 
Top