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,'Shee t
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..................Ele ctric....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" wrote in message
...
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