Hi Kaushik, Thanks for help but when i do that it will pick the very first value in the table array and does not get me the desired values. Below is the table 1 which was refering to.
Department City Name Level Plan Hrs Plan %age Actual Hrs Actual %age
Marketing A Anand Manager...
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...