how do I link 2 differnt spreadsheets to pull specific info.

[robyn_willson]

I am trying to link two Excel (2003) spread sheets so that I can pull
specific information from one and add it to the other. An example would be:
if I have a large list of companies in one spreadsheet and I would like to
pull out all the information on all companies with more than 20 employees.
This information would be displyed in the second sheet. Or in the second
sheet I only want to see the companies and their information if they are
located in a specific city. Please help or at least show me where to get
started. Thanks.

 

[JLatham]

I need to first ask if these are two sheets in a single .xls file or if we're
talking about working with 2 sheets in 2 separate .xls files. Some of the
methods that might provide a solution would require that both workbooks
(separate .xls files) be open at the same time. That wouldn't be a
consideration if it is 2 sheets in the same file.
Offhand it sounds like you're probably going to be looking at using some
VLOOKUP() formulas an perhaps some variation of SUMPRODUCT() to get to the
information.

 

[Suleman Peerzade]

Hi,

Suppose you have two col A and col B insheet 1 and in col A you have the
company names and in col B you have the number of employees. Now in sheet 2
col A2 you can type this formula
It would look something like this.
=VLOOKUP(A2,Sheet2!A2:B100,2,FALSE)
--
_______________________
Click "Yes" button if it helps
________
Thanks
Suleman Peerzade