Comparing Two Sheets
 

I want to compare two sheets:

1st sheet
Customer Date of Last Purchase
2nd Sheet
Customer Email Address Fax Number Market Segment Rep

I want to compare the customers from sheet 1 and 2 and diplay the following
on sheet 3

Customer Date of Last Purchase Email Address Fax Number Market
Segment Rep


Is this possible to say if customer from sheet 1 equals customer from sheet
2 then display the following on Sheet 3?

Thanks for your help,

Assumptions:
Sheet2 contains all of the customers
Sheet1 contains no more than 1000 customers

A1: =Sheet2!A1
B1: =VLOOKUP(A1, Sheet1!$A$1:$A$1000, 2, FALSE)
C1: =Sheet2!B1
D1: =Sheet2!C1
E1: =Sheet2!D1
F1: =Sheet2!E1

Copy row 1 down for as many rows as necessary.

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Pete Petersen" wrote in message
...
I want to compare two sheets:

1st sheet
Customer Date of Last Purchase
2nd Sheet
Customer Email Address Fax Number Market Segment Rep

I want to compare the customers from sheet 1 and 2 and diplay the
following
on sheet 3

Customer Date of Last Purchase Email Address Fax Number Market
Segment Rep


Is this possible to say if customer from sheet 1 equals customer from
sheet
2 then display the following on Sheet 3?

Thanks for your help,

Comparing Two Sheets
 

I am trying to do something similar - but want to fill to the last row
without manually changing the range for the last row. any hints?

"Rob van Gelder" wrote:

Assumptions:
Sheet2 contains all of the customers
Sheet1 contains no more than 1000 customers

A1: =Sheet2!A1
B1: =VLOOKUP(A1, Sheet1!$A$1:$A$1000, 2, FALSE)
C1: =Sheet2!B1
D1: =Sheet2!C1
E1: =Sheet2!D1
F1: =Sheet2!E1

Copy row 1 down for as many rows as necessary.

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Pete Petersen" wrote in message
...
I want to compare two sheets:

1st sheet
Customer Date of Last Purchase
2nd Sheet
Customer Email Address Fax Number Market Segment Rep

I want to compare the customers from sheet 1 and 2 and diplay the
following
on sheet 3

Customer Date of Last Purchase Email Address Fax Number Market
Segment Rep


Is this possible to say if customer from sheet 1 equals customer from
sheet
2 then display the following on Sheet 3?

Thanks for your help,