Determine cell value based on list from other sheet

[TBAnashdk]

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!!

 

[Guest]

in F1

=if(G1="","",vlookup(G1,Sheet2!A:B,2,false))

 

[TBAnashdk]

Perfect Tom- Thanks sooo much!!

in F1

=if(G1="","",vlookup(G1,Sheet2!A:B,2,false))

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

[quoted text clipped - 3 lines]

Thanks for you help!!