Hi. I'm using Validation for a list of selectable names. I also have
a list of coressponding email in another column. I'd like to be able
to select a name from the validation list and show the corresponding
email in another field once the name is selected. Is this possible?

Yes, I wanted the same occurrence to happen for a hockey pool. Here is what
I used:

Ex:
A1 = Name
B1 = Email
C1 = Name List
D1 = Show Email

=VLOOKUP(<cell reference for name list, <range of names and emails,
<column that email is, FALSE)

This would be put into cell D1:
=VLOOKUP(C1, $A$1:$B$1, 2, FALSE)


This worked for me by selecting a name from a list and it will show the
corresponding point value for the player.

Hope this helps.


On 5/14/08 12:08 PM, in article
, "KLZA"
wrote:

Hi. I'm using Validation for a list of selectable names. I also have
a list of coressponding email in another column. I'd like to be able
to select a name from the validation list and show the corresponding
email in another field once the name is selected. Is this possible?