Excel 2007 : Lookup table Loop

[grassasp]

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

[TMS]

Do you think it would help to post a sample workbook and some typical data and explain what that formula is supposed to do and how you "loop through it".

I'm just a little confused.

Regards

[grassasp]

Let me try again. I attached a sample source. Thank you.

Tab Data; I need to pull from the column "Data" the total amount of pages printed in simplex vs duplex.

Example: "SYSNAME=iR8070;CANON_101=101042;CANON_103=25;CANON_201=98454;CANON_203=25;CANON_DEVICENAME=iR8070;"

Based on the lookup table i need to classify each Cannon_### as simplex and duplex and sum. The classifications are on the tab "lookup table".

Cannon_101=101042 is 101,042 pages printed Simplex.