Excel Spreadsheet Question

James240

Hiya guys and girls im hoping someone might be able to help me Ive created a drop down list in an Excel spreadsheet that my staff can use when completing a training return form. What i would like to do is when they select the appropriate option from that list, that the correct email address would appear in another cell that they have to send this information to. Can anyone help me how i can set this up Thanks James

bluboy

Using Nested IF function
Imagining your drop down list (e.g. Peter, John, Paul) is in cell A1 ...
In the cell where you want the email address to appear type -
=IF(A1="Peter","peter@gmail.com",IF(A1="John","john@gmail.com",IF(A1="Paul","paul@gmail.com")))

HTH

PhilCo_2

You'll need a list of the options with the appropriate email next to it. Then in the cell you want to put the email in use a vlookup to lookup the selected dropdown value against the list and return the email address.

Oscar_The_Grouch

If you go HERE you can search for instructions on the vlookup function, which should help.

Little_Miss_Uni-Debt

Yep, I'd say the nested IF statement is the easiest way to do it

michaelro

Vlookup - That's what it's there for.

Nested IF's stop at 8 and are far to cumbersome for something like this

Create a list of your original value and the lookup value you wish to return

If your drop down value is in A1 and your lookup list in D1 to E50 then put the following formula in B1

=VLOOKUP(A1,$D$1:$E$50,2,0)

The relative reference $ will ensure the list still refers to the correct place when you copy the formula.

James240

Thank you very much guys you have helped me out massively
Ill thank you all when i get home as the works computer doesnt allow me to use the button

althas

VLOOKUP is the way to go for sure. The nested IF statements (as been said already) is a cumbersome and long winded way of doing this particular thing

Also with the vlookup, it will be easy to change in the furture, as you will only need to change the list as opposed to every instance if the nested IF function