Sep 14 2020 04:40 PM - edited Sep 14 2020 05:46 PM
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.
Sep 14 2020 08:26 PM
@RobertP90 Try VLOOKUP as in the attached file. If you are a MS365 subscriber, I'd suggest you look into the new XLOOKUP function.