I have Two tables one filled with different departments details and the other one being empty.
I have created a data validation list on top of the empty table for departments. I need help in getting the formulas right to get only the department wise details in the empty table.
Note that both...