I have attached 3 sheets in word doc . I have very simple one conditions that goes in main sheet column D8
Issues I am getting is : I have to compare Roomids, Day Name and time slot to put correct values.
How to match Roomids, Day Name and time slot in Sheet 1 and Sheet2 to Main Sheet and put the above formula?
Sheet 1 and Sheet2 have similar pattern.
To facilitate testing, please attach your sample Excel file.
@Twifoo : Apologies. Please find sample for testing.
Thank You. It worked for me.
Sorry for late reply.
@shilpa288 , you are welcome