Determine cell value based on list from other sheet
 

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

Determine cell value based on list from other sheet
 

in F1

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

--
Regards,
Tom Ogilvy


"TBAnashdk" wrote:

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

Determine cell value based on list from other sheet
 

Perfect Tom- Thanks sooo much!!


Tom Ogilvy wrote:
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!!