Formula using text contained in a cell as criteria

Hi everyone,

I have 2 interesting sheets with a couple thousand rows each.
Columns in DOCUMENT1 going like this:
(1)Actual Costs (2)Reference #
/Formula XXX000000


Columns in DOCUMENT2:
(3)Actual Costs (4)Description
$$(What I need) Description (Including a reference number somewhere XXX000000)

I need a formula that will seek the reference number (2), letters and numbers in DOCUMENT2's Description row(4) and bring me back the adjacent actual cost(3).

The simple formula I have built so far, and which is causing me some problems is the following:

=SUMIF('C:\FILEPATH[FILENAME]WORKSHEET'!$A:$A,T(B6),'FILEPATH[FILENAME]WORKSHEET'!$B:$B)

It works fine, except for the CRITERIA, which I can't seem to get to work to find something "CONTAINED" rather than exact.

Anyone who could give me a hand, this would be very appreciated =)


<config>Windows XP / Internet Explorer 7.0</config>

Thanks, actually I didn't know how to add those wildcards on. I tried without the & and I was putting the " at the wrong places (beginning and end)

I've never used the & symbol, what exactly is it's purpose?