Please Help! - Need Help pulling data from one spreadsheet to anot

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

Guest

I have two spreadsheets

The first lists URLs for several hundred companies along with the number of
email addresses associated with that company. This work sheet is called
"Domain"

Example

Column 1 Column 2
URL # of Users
abc.com 1234

The other lists company names, city and state locations and the URL for that
company. It is called "Blitz"

Example

Column 1 Column 2 Column 3 Column 4
ABC Company New York NY abc.com

I want to compare Domain and Blitz based on the URL. If a URL on "Domain"
is also located on Blitz, then I want to pull the number of users and
pre-populate a new column 5 in Blitz called "# of Users"

This way I can find out which companies in my area have the most number of
users.
 
Hey, I figured it out on my own using VLookup. Pretty cool.

=VLOOKUP(A:A,'C:\Documents and Settings\Owner\My Documents\a. CCTS\[Domain
Search.xls]Complete List'!$1:$65536,3,FALSE)
 

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

Copy Data from One Spreadsheet to Another ?????? 5
Separating data from cells 18
Collate data from one spreadsheet into another spreadsheet 2
Link cells to pull specific data 4
Create a macro to eliminate certain words from several columns 4
Data Group Total 3
Help w/Match or Lookup 2
Need Help FAST with COUNTIF Formula 0

Back
Top