Find a number sequence in cell range and return all information from cell if found

[vman5781]

I am try to cross reference 2 sheets -- 1 tab will have a Column of Account numbers (data) -- the other tab (TRECS) may have the account number within a sequence of other information (description) -- if account number is found I want it to bring all the info from cell it was found in

eg:

Data tab =b2= 111104618

TRECS tab c1772 = 0264-CK-0111104618-0000 - CK - TTC - Flexible Reimbursement Account


Any help on thi ? I have tried Vlookup, Find and search -- not sure if I am writing it correctly

 

[Fluff]

Something like
=VLOOKUP("*"&B2&"*",TRECS!C$2:C$2000,1,0)

 

[vman5781]

Works perfectly thank you

 

[Fluff]

You're welcome & thanks for the feedback