- 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.
@RobertP90 Try VLOOKUP as in the attached file. If you are a MS365 subscriber, I'd suggest you look into the new XLOOKUP function.