Vlookup help

Hi Excel Gurus,

I am stuck in a situation where I am not being able to express my problem correctly. Let me try this once.

I have this file where I have some POs in column A of sheet1, I need to get the tracking infos from sheet2. I can use vlookup but the problem is that I have all the PO in format "TKO-247" in sheet1 where as in sheet2 the PO can be in any cell of column A and anywhere also the format can be "TKO/247", "TKO 247", "TKO247".

I hope I was able to make u understand.