Thread: Pulling relative information from a seperate workbook
View Single Post
  #2  
Old 07-01-2009, 01:23 AM
kimbal kimbal is offline
Registered User
  
Join Date: 15 Jun 2009
Location: Hong Kong, CN
MS Office Version:Excel 97-2010
Posts: 17
kimbal is becoming part of the community
Re: Pulling relative information from a seperate workbook
Hi Effteekay,

Does the vlookup formula help?
Please take a look at Column B of WS2.
just changing the reference in the formula ws1!$A:$B, so you can match the record with different workbook.
Attached Files
File Type: xls ef0701b.xls (13.5 KB, 5 views)
__________________
We build a new way to dream
http://kimbalko.blogspot.com
Reply With Quote