Variabel text in MID. VLOOKUP?

Hi all- Does this ARRAY FORMULA work? It requires Name on the left end and (initials) on the right end of the found string = James...(JE)

Formula:

=LEFT(RIGHT(OFFSET($H$80,MIN(IF(LEFT($H$80:$Q$87,LEN(H66))=H66,ROW($H$80:$Q$87)-ROW($H$80))),MIN(IF(LEFT($H$80:$Q$87,LEN(H66))=H66,COLUMN($H$80:$Q$87)-COLUMN($H$80)))),3),2)

here's the same formula with semi-colons instead of commas:

Formula:

=LEFT(RIGHT(OFFSET($H$80;MIN(IF(LEFT($H$80:$Q$87;LEN(H66))=H66;ROW($H$80:$Q$87)-ROW($H$80)));MIN(IF(LEFT($H$80:$Q$87;LEN(H66))=H66;COLUMN($H$80:$Q$87)-COLUMN($H$80))));3);2)

*You must press CTRL+SHIFT+ENTER to confirm entry of an ARRAY FORMULA in the Formula Bar.
When copying the formula to other cells, make sure the copied cell is not part of the Paste Area.

Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee

I am not sure where to swap ";" and "," for regional settings. This formula is the American version. The file is attached. Hopefully your settings will correct.

Formula:

=TRIM(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(INDEX($C$3:$E$4,MATCH(1,MMULT(--ISNUMBER(SEARCH(A1,C3:E4)),

ROW(INDIRECT("1:"&COLUMNS($C$3:$E$4)))^0),0),MATCH(1,MMULT(COLUMN(INDEX(1:1,1):INDEX(1:1,ROWS($C$3:$E$4)))^0,

--ISNUMBER(SEARCH(A1,C3:E4))),0)),A1,""),"(",""),")",""))