archanair
New Member
Sheet 1: Dashboard
Sheet 2:US India employee list
What is required?
Based on the entry in the dashboard for the year and month I need to retrieve the list of exited employees from the master sheet(Sheet 2).
eg. If we select year as "2022" in cell O26 and month as "Jan" in cell O27 my formula should be able to retrieve the list of exited employees who exited in Jan 2022 from Sheet 2 and list in sheet 1 in the below format.
Cell Values
In Sheet 2 which is the master sheet below columns have the exit data
Column V: Date of Leaving
Column W : Year of Leaving
Column X: Exit Type
Column B:Region
Sample File link :https://docs.google.com/spreadsheets/d/1jLGvwH3O62Yft8jtuznQ6r4f7xyvRWQq/edit#gid=2138561937
Please Help!
Sheet 2:US India employee list
What is required?
Based on the entry in the dashboard for the year and month I need to retrieve the list of exited employees from the master sheet(Sheet 2).
eg. If we select year as "2022" in cell O26 and month as "Jan" in cell O27 my formula should be able to retrieve the list of exited employees who exited in Jan 2022 from Sheet 2 and list in sheet 1 in the below format.
Names | Leaving Date | Exit Type | Region |
Cell Values
In Sheet 2 which is the master sheet below columns have the exit data
Column V: Date of Leaving
Column W : Year of Leaving
Column X: Exit Type
Column B:Region
Sample File link :https://docs.google.com/spreadsheets/d/1jLGvwH3O62Yft8jtuznQ6r4f7xyvRWQq/edit#gid=2138561937
Please Help!