VALIDATION FUNCTION HELP

[KLZA]

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?

 

[Kurt Ferguson]

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.