Search, Calculate and Display

[James2000]

Hi,
I am trying to get a set of budget totals off of several worksheets. The
problem is that I need to sort out the figures according to specific
codes/keys that are not unique. I then need to get the data that it pulls
onto a budget report sheet in an easy to read total column.

Any suggestions as to which formula would work best? Or would I need to nest
several IF type formulas?

Thanks,

 

[Patti]

You might be able to make the codes unique by
using "Concatenate". For example, if your accounts are
(with the first 120 being in cell A1 and the first 10 in
cell B1):

120 10
120 11
130 10
130 11

Enter this formula in a helper column and copy down:

=A1&B1

So now you'll have:

12010
12011
13010
13011

 

[James2000]

That would work if I was seeking to create individual/unique numbers, but I
already have the unique numbers. What I need now is to tell Excel to search
for thos numbers and then gather info from a cell in the row, with that
number as the key of the row.

Can get a simplified version to work using VLOOKUP, but there are several
individual keys, so does this mean that I need several seperate VLOOKUP
functions?
J2K

 

[Patti]

Sorry! I misunderstood.

Maybe post a sample of your table -- Lookups, Index/Match
or Sumifs are possible depending on what your data looks
like.

-----Original Message-----
That would work if I was seeking to create

individual/unique numbers, but I

 

[James2000]

The table looks roughly like this (sorry about the alignment):
the 1st colum is the code that i need to sort according to
the 2nd is date
3rd is the sum that i need to calculate off of
the rest doesnt matter

1000 17/08/2004 £1,852.00 Repayment to Account 1852 1852;
2 18/08/2004 £27.31 1003 HP Laserjet cartridge 5634;
1701 02/09/2004 £645.33 1322 Photographs,proof prints &
transparencies 217 1344;
2 02/09/2004 £323.17 1322 Photographs,proof prints & transparencies 217 1344;
2 13/09/2004 £46.42 1344 HP Laserjet cartridge 5634;
1710 13/09/2004 £82.13 1344 Epson EPL 5900L cartridge 5634;

i have managed to make use of multiple vlookups, but that gets cluttered.
Any other suggestions plese?
Thanks
J2K