Hi,

Iīm trying to do the following:
I write a name in A1. The formula searches in C3-E4 to find that name. If it finds it it returns the initials between the paranthesis.

I canīt, for different reasons, separate name and initials in different cells and just use VLOOKUP. That is, I canīt change the way the document looks. (The image is just a simplified version of the big document who we send out externally).

This far I have just used:
=MID(C3; SEARCH("(";C3)+1; SEARCH(")"; C3)-SEARCH("("; C3)-1)

Above doesnīt work since I want to be able to change name in A1 and therefor get different initials in B1. I tried exchanging C3 with VLOOKUP(A1; C3:E4; 1; TRUE) but it doesnt gave me a correct value back. (and probably is completely wrong but Iīm kind of stuck here..)

So question is: What formula can I use to be able to do this?

Many thanks!
//Erik

excel.JPG