Comparing Two Sheets

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

Guest

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.
 
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?
 
Back
Top