I am adding this to an exsisting spreadsheet that already has information on
it, so I cannot use a Pivot table.

I am trying to use:

=IF(VLOOKUP(B2,'Sheet 1'!A1:F1262,5,FALSE)="Gas",AND,IF(VLOOKUP(B2,'Sheet
1'!A1:F1262,6,FALSE)="Dec-04",VLOOKUP(B2,'Sheet 1'!A1:F1262,2,FALSE)))

"JulieD" wrote:

> Hi
>
> would the following structure be acceptable:
> .......................Dec 04........................Jan 05
> Name.........Electric.....Gas..................Electric....Gas
> Joe Bloggs...6.....................................................10
> Jemma..................................................5.............2
>
> if so, it can easily be achieved from your current data using a pivot table
>
> click in your current data, choose data / pivot table and pivot chart report
> NEXT
> ensure that the whole range is selected NEXT
> ensure new worksheet is selected and click LAYOUT
> drag name to where it says "ROW"
> drag date to where it says "COLUMN"
> drag type of bill to where it says "COLUMN" ensuring it goes to the right of
> date
> drag cost to where it says "DATA"
> click OK click FINISH
>
> now right mouse click on Date and chose field settings, change automatic
> subtotals to none
> and you should have more or less what you're looking for.
>
> -
> Cheers
> JulieD
> check out www.hcts.net.au/tipsandtricks.htm
> ....well i'm working on it anyway
> "Natalie" <Natalie@discussions.microsoft.com> wrote in message
> news:CC0AFAAB-2B63-4102-A533-793258DAD2DC@microsoft.com...
> > Hi,
> >
> > I have one worksheet with information for lots of people, but on separate
> > rows -
> >
> > Name Date Type of Bill Cost
> > Joe Bloggs Jan 05 Gas £10
> > Joe Bloggs Dec 05 Electric £6
> > Jemma Jan 05 Gas £2
> > Jemma Jan 05 Electric £5
> >
> > I want to add them to a new sheet, which is set out as:
> >
> > Name GasDec04 GasJan05 ElectricDec04 ElectricJan05
> > Joe Bloggs 0 £10 £6 0
> > Jemma 0 £2 0
> > £5
> >
> > Can I use a lookup to do this?
> >
> > Thanks
>
>
>