Create a table with two columns, column A would be a name, Paul etc,
column B would contain the equivalent email address from column A

Select the range of data entered then choose Insert Menu and Name and
enter a name for this range. Then use Data Sort (this function wont
work unless the data is sorted into order).

Highlight the cell you want say C2 and enter this formula

=VLOOKUP(D1,TEST,2)

If you enter a name in D1 the email address will appear in D2

Regards
Special-K


--
Special-K
------------------------------------------------------------------------
Special-K's Profile: http://www.excelforum.com/member.php...fo&userid=7470
View this thread: http://www.excelforum.com/showthread...hreadid=562465