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

Hi!

One way:

=INDEX(E:E,MATCH(A1,E:E,0)+2)

Biff

"elrussell" wrote
in message ...

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

thank you!


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

You're welcome!

Biff

"elrussell" wrote
in message ...

thank you!


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

Hi,
Sorry, I just realized the similarity of this posting and mine. Could
you help me too?

I have copied part of the post here for you...


..This is the first time I have ever posted a question on the internet,
..so bear with me, I will do my best to be clear and concise for anyone
..who may be interested in helping me look good to my boss! :))

..Seems the easiest way to do this is tell you what I need the formula
to
..do, so here goes...


..User Facing I would like to see two columns, #1 is 'Req. Number' and
..#2, is 'Position'. In order to streamline data as well as to save
..time on data entry, a user would only need to enter a desired req.
..number into column 1 of the row they are working on. The formula I am

..looking for would be able to then take that number, reference
..previously entered (possibly hidden) data, and then be able to report
....
..I KNOW excel can do this. It has to be one of the most basic things
it
..does, yet I can no longer sift through all these commands knowing that

..someone out there knows that this is a cinch. If that person is you,
..dear reader, please take pity on the girl who is still working at 9:00

..on a friday night and at least give me a hint?

It occurs to me that I may be able to figure out how to work the
previously posted formult to my use, but after trying to figure it out
on my own for so long before coming here for help, I feel as if my
brain is melting! (eew) Meaning, I don't think I would get very far
with such a venture tonight.


Please just let me know if you can help me.

THANK YOU! Even if you can't help, thanks for at least attempting to
by reading this.


MANDA
San Jose, CA
Okay, so like I said, I've never done this...do I leave my e-mail for
quickest response?


-- too late now I guess!