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

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)

"dhwinters" wrote:

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