How to make a cell only allow certain values

[cav~firez22]

Ok, this refers to a previous question i had about vlookup

How to make B1 only allow the following.

VAN
VER
SAC
SLC
FIF
HFX
TOR
ATL
EDM
JCK

These are the only things that this cell should be allows to have in it. how could i make that happen. This cell is reffered to in a vlookup with indirect leading to this cell..


any ideas on this??

 

[lenze]

Check out Data>Data Validation. You probably want to use the List option with a dropdown.

lenze

 

[NateO]

Data->Validation. Allow: List. What to enter? List, each item separated by commas.

• Edited by Nate: Too slow...