Want to populate a cell with specific text based on a range of values in another cell

[rcw464]

I need a formula that look at the drop down item selected from the drop down menu in column E, and based on what it sees it populate the cell in column F with a specific text. In the example pic the possible selections from the drop down are JC1 to JC8, for anything in the range I would want the text in the adjacent cell in column F to read "Juniper Creek".

 

[Joe4]

You can create a lookup table and use a VLOOKUP formula to do that.
See here for details: MS Excel: How to use the VLOOKUP Function (WS)

If you want it to return nothing until cell E1 is populated, you can wrap it in an IF statement, i.e.

=IF(E1="","",VLOOKUP(...))