Prev: Formatting does not follow when copying from one cell to another
Next: How do I write this logical argument?
From: joahusa on 7 Apr 2010 17:04
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" <PetePetersen(a)discussions.microsoft.com> wrote in message
> news:6BB1E215-4F20-4CAF-AEEF-2D616641E199(a)microsoft.com...
> >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,
>
>
>
 | 
Pages: 1
Prev: Formatting does not follow when copying from one cell to another
Next: How do I write this logical argument?