So here is my dilemma. I have a worksheet I export daily and it contains the name of the individual who opened the account but is have the name inside parentheses. I have another worksheet that has just the account number and I need just the individual name from the other worksheet. I have been using =IFERROR(INDEX('Dashboard Export'!K:K,MATCH(Tracker!H:H,'Dashboard Export'!L:L,0)),"") to grab the info but it grabs everything in that cell and I just want the name between the parentheses. I found this formula =MID(K22,SEARCH("(",K22)+1, SEARCH(")",K22)-SEARCH("(",K22)-1). But I can't for the life of me figure out how I would use both formulas to get what I want. Anyone have any suggestions for me?
Thanks a buch
Thanks a buch