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 ca 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
Bookmarks