I am working on a formula and cannot get it to return correctly, I need to be able to select one of two options in a dropdown. I was using a vlookup and kept getting the N/A for all of them even if the condition was met. I think I missed an additional trigger.
Regions: ABC and XYZ for the example.
Based on which region they choose there will be other columns that need to be given a "N/A"
For example if ABC is selected then the rows specific to XYZ would receive the gray, and vise versa. There is about 20 rows that would need this formula for an undetermined amount of people (the sheet grows).
I could do conditional formatting but my stakeholders would like something a little more obvious which is why I thought of assigning the columns the N/A would be better.
