search for a "part number" within a string and return its cell position or contents of cel

parts x referance.xls Good afternoon,
I am having trouble with a set of spread sheets. I am a maintenance technical writer and way out of my league writing formulas or vbm in excel. I am looking for a part number that is in cell b2 within a string of text on a separate worksheet page and then return either the completed string of text where it is found or the cell address where it can be found.

my worksheet is setup like this

Page 1
a b c d
1 Part # part ## found # Found ##
2 6T-0302 6T0302
3 310-9247 3109247
4 01R-2357 01R2357

Page 2
a b c
1 Mat # Description Unit
2 20000168 Link,cat 6T0302 ea
3 20001424 Hitch,cat 7G6623 ea
4 40026564 filter;cat 310-9247 ea
5 40004487 bolt;unc3/4x4" ea

so in cell c2 i need either page 2 b2 or b2 or "Link,cat 6T0302".

I hope someone can help i have tried using a find formula but can only get it to return a 1 or a 0

Your help would be greatly appreciated.

Ben

Re post i have attached a sample copy of the workbook i am working on and have placed some comments in it to explain a little bit further as to what i am looking for.

Hi, i have added a workbook which shows you some formulas to get what you want