Ok, this is a very crude solution, but it works...

Enter the following formula into column E:

=A2&B2

And in column F:

=A2&"Managing Director"

Then in column D:

=INDIRECT(ADDRESS(MATCH(F2,E:E,0),3))

You can hide columns E&F if you like.


--
Montrose77
------------------------------------------------------------------------
Montrose77's Profile: http://www.excelforum.com/member.php...o&userid=18191
View this thread: http://www.excelforum.com/showthread...hreadid=492239