I want to run this formula:

=IF((ISERROR(SEARCH(X,E1,1))),0,(MID(E1,(SEARCH("=",E1,FIND(X,E1,1)))+1,(FIND(";",E1,SEARCH(X,E1,1)))-(FIND("=",E1,SEARCH(X,E1,1)))-1)))

Where X changes and loops from a table. The table is located in cells A1 to A150 on tab ESA.

Sample located at E1 : SYSNAME=iR C5870;CANON_101=121016;CANON_108=73473;CANON_229=174;CANON_230=10183;CANON_321=33;CANON_322=37153;CANON_DEVICENAME=iR C5870;

Sample lookup table:
Canon_019
Canon_021
Canon_023
Canon_114
Canon_116
Canon_230
Canon_235
Canon_322