Ok, I am trying to get cell f1 to fill in automatically based on the value of
G1. On another sheet I have a list of names in column A and corresponding
codes in cloumn B. If the user inputs "denver" from a pull down menus in G1-
I want it to find "Denver" on the list and display the code (that is in the
cell next to denver on the other sheet) in Cell F1.

Thanks for you help!!