Look for and return text string, based on certain criteria

[James_Hockley]

Hi, i'm looking for a formula/script that will be able to solve the following.

If cells A12 through A16 contain any one of the text in cells A3:A6, it is to look for the associated text string (wildcard numbers) B3:B6 in the text B12:B17.

Not all cells will return a result.

Thanks

[#2 · Accepted solution]

@James_Hockley 

=IF(NOT(ISNA(MATCH(A12,$A$3:$A$7,0))),RIGHT(B12,LEN(B12)-SEARCH(INDEX($B$3:$B$7,MATCH(A12,$A$3:$A$7,0)),B12)+1),"leave blank")

Maybe with this formula as shown in the attached file.

[#3]

That looks great, thanks very much