Display / Lookup

%3CLINGO-SUB%20id%3D%22lingo-sub-1666624%22%20slang%3D%22en-US%22%3EDisplay%20%2F%20Lookup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1666624%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%26nbsp%3B%3C%2FP%3E%3CP%3E-%20I%20hope%20someone%20can%20help%20me%20here.%26nbsp%3B%3C%2FP%3E%3CP%3E-%20I%20will%20like%20one%20cell%20to%20display%20based%20on%20the%20selection%20of%20a%20different%20cell%20that%20has%20a%20drop%20down%20menu%20with%20values%20assigned%20on%20a%20different%20tab.%26nbsp%3B%3CBR%20%2F%3E-%20I've%20attached%20a%20dummy%20file.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%26nbsp%3B%20you%20very%20much.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1666624%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

Hello, 

- I hope someone can help me here. 

- I will like one cell to display based on the selection of a different cell that has a drop down menu with values assigned on a different tab. 
- I've attached a dummy file.  

 

Thank  you very much. 

1 Reply
Highlighted

@RobertP90 Try VLOOKUP as in the attached file. If you are a MS365 subscriber, I'd suggest you look into the new XLOOKUP function.