I make this table, and I try to make search feature by using drop down menu and vlookup formula, I use data validation to add HVAC Unit & Number, the problems am facing the following:
1. After I add HRU units number, I change HVAC Unit to FCU and I try to add drop down list for number from below table after I do this step through data validation it will change also number for HVAC unit.
2. After changing number it will not return correct data for Building, Location and Level from below table.
Please advise what is the mistake I did and how can I correct it. " I want to learn "