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