vlookup contains?

[stevotsky]

I have a spreasheet with the following data

Column1
Purchasing
Sales
Payroll
401
w/o
Without
Bonus
4/4/5
4-4-5
4.4.5
Amortize
100-200
OH


Column2
A/P
A/R
Honey
401(K)
100-200 REC
100-200 REC
Bonus
4/4/5 REC
4/4/5 REC
4/4/5 REC
Prepaids
100-200 REC
OH Alloc

Column3
401-k-payment
payroll raise
sales pitch in MN etc


I would like to create a formula that looks up values in column 1 to see they are part of those in column3 (for example 401 is part of 401-k-payment). If that is true, then I want column 4 to give me 401(k) - the value in column2.

Thanks for your help.