This should be simple, but I have a blind eye for it right now. I have a
list of names in column A. In column E the user drags a list of names
from their Outlook Express Address book in this column format:

Name1 (in same format as column A)
label1
email address1
Name2
label2
email address2
(and so on...)

In column B, next to each name I want to put a formula that looks up
the corresponding name in column E and off-sets down 2 rows to grab the
email address.

I 'know' the row,column of the corresponding name. I can get the row
number of the corresponding name using Match, but I forget what
function I must wrap around this information (remember the column is
5) to extract the email 2 rows down.

Thanks in advance!


--
elrussell
------------------------------------------------------------------------
elrussell's Profile: http://www.excelforum.com/member.php...o&userid=31020
View this thread: http://www.excelforum.com/showthread...hreadid=530788