twist on nth ocurrence of text in column

[DThib]

I have the formula below working but I need it to pull a portion of the text found not the whole string. My fix is from another formula I worked out. but it is throwing an error.

Can anyone help me fix this to work? I have bolded what I need it to find for every iteration. It is supposed to find the word and then pulls the number after.

=INDEX('Run Data'!$A:$A, SMALL(IF(ISNUMBER(SEARCH("Run", 'Run Data'!$A:$A)),ROW(MID('Run Data'!$A:$A,SEARCH("Run", 'Run Data'!$A:$A)+3,2)),2)))

Finds Example entire string: 1120-01X TK Run15 19Nov2008 Plate01: Expired Date Table

DThib

 

[DThib]

I am trying this formula to pull the numbers I need, but it keeps giving me a #NUM result.

=INDEX('Run Data'!$A:$A,SMALL(IF(ISNUMBER(MID([COLOR=#222222][FONT=Verdana]'Run Data'!$A:$A,[/FONT][/COLOR]SEARCH("Run",'Run Data'!$A:$A)+3,2),ROW('Run Data'!$A:$A)),2))

If I leave out the MID function I pull the whole 2nd occurrence but not just the 2 numbers after "RUN".

=INDEX('Run Data'!$A:$A,SMALL(IF(ISNUMBER(SEARCH("Run",'Run Data'!$A:$A)),ROW('Run Data'!$A:$A)),2))

Will pull the entire 2nd occurrence text: VFG-0xxS TK Run15 19Mar2018 Plate01: Experiment Data Table

Can anyone help?

I am still trying to solve this. Can one of the brilliant VBAers please help!

DThib

 

[Rick Rothstein]

I am still trying to solve this. Can one of the brilliant VBAers please help!

I am unclear as to exactly what you have (multiple columns and rows? single column A?) and exactly what you want from it. Can you give a larger sampling of data and show exactly what you want from the sampling you post?

Also, you asked for help from VBAers but you seem to be after a formula solution, not a VBA coded solution... please clarify.