Index / Match with Wildcard Not Working

HI Everyone,
I'm a long time viewer, but brand new member(and super excited to be part of this group).

I'm in need of assistance on an index/match with wildcard formula.

For the life of me I can't get this one to match. Hopefully you can help.


Formula: =IFERROR(IF(A78="","",INDEX(Raw!B:B,MATCH("*"&A78&"*",Raw!A:A,0),1)),"")


Context:
Attempting to match an 8 digit number within a list of a string of 8 digit numbers separated by semicolons.
In my example you can see where there is clearly a match, but the formula is not recognizing it.

I can't seem to attach my work here, so I'll try to list it out this way:


(Column A Active Sheet) (Column B Active Sheet(Where Formula Is)
Active Reference: Required Return:
25549813 #N/A



Raw Data Sheet has a match of the below in column A: You can see the match is number 6 in the string
25549483;25549487;25549531;25549546;25549754;25549813;25549827;25550129;25550153;25550154;25550156;25550157;25550158;25550159;25550162;25550163;25550164;25550199;25550203;25550205;48041897;48041948;48042458;48042613;48042667;48045684;48045687;48045749;48045774;48045973;48046029;95706118

Column B is the column i'm trying to get the return from. But i get the standard #N/A error.

Any ideas?

Again, sorry I can't insert my excel sheet, it's not giving me an option when i hit the attachment button.

THANKS IN ADVANCE!

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook (it does not include using the attachment button for the reason you have discovered already).

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

Try this in B2 copied down:

=IFERROR(IF(A2="","",INDEX(Raw!B:B,MATCH("*"&A2&"*",Raw!A:A,0),1)),IFERROR(LOOKUP(99999,SEARCH(B3,Raw!$A$2:$A$25),Raw!$B$2:$B$25),""))

In B2 copied down:

=IFERROR(LOOKUP(99999,SEARCH(A2,Raw!$A$2:$A$25),Raw!$B$2:$B$25),"")

If this isn't right, then provide a workbook with this applied and highlight the rows that are incorrect - in column C, manually enter what you are expecting.

Glad to have helped.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.