We may need some more examples of your data, but see if this gets you headed
in the right direction...

With
Sheet2...
H2:H15 containing accounts
I2:I15 containing numbers

If the account references are TEXT,
then this may work:
=SUMIF(Sheet2!H2:H15,"*9330",Sheet2!I2:I15)

However, if the account references are numeric,
you may need something like this:
=SUMPRODUCT((RIGHT(Sheet2!H2:H15,4)="9330")*Sheet2 !I2:I15)

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"stefburgas" wrote:

Is it possible in excel to use a wildcard search function, I have looked in
the help file and it mentions using * but this doesn't seem to do what I
want.

I am trying to vlookup a column against another worksheet where i have
account numbers for two cost centres, i.e 9330 and 54009330 so I want to
determine the balances by account i.e have two lines on another spreadsheet
one for 9330 and one for the second centre. However the cost centre part of
the account will change but the account number 9330 will remain the same.

Is this possible if so how