D
donbow
Hi I am trying to summarise the following:- Col A = Cost Centre Col B
Account, Col C = Description, Col D = Amount. There are 4 Cost Centr
values, each cost centre can have between 200 and 700 accounts, th
account numbers are mainly the same in each cost centre, the amount
all different. I want to summarise the list in another sheet by Col A
Account, Col B = Description, Col C = Cost Centre 1, Col D = Cost Centr
2 Col E = Cost Centre 3, Col F = Cost Centre 4. The summary would onl
show a value under Col C-F if there was an amount in the first lis
against the account number. I have tried LOOKUP, HLOOKUP, but don'
think I am on the right track I don't want the nearest value if ther
is no value in the first list
Account, Col C = Description, Col D = Amount. There are 4 Cost Centr
values, each cost centre can have between 200 and 700 accounts, th
account numbers are mainly the same in each cost centre, the amount
all different. I want to summarise the list in another sheet by Col A
Account, Col B = Description, Col C = Cost Centre 1, Col D = Cost Centr
2 Col E = Cost Centre 3, Col F = Cost Centre 4. The summary would onl
show a value under Col C-F if there was an amount in the first lis
against the account number. I have tried LOOKUP, HLOOKUP, but don'
think I am on the right track I don't want the nearest value if ther
is no value in the first list