Copy cell value between sheets if it matches a criteria

Prashanth - Jun 23, 2016 at 11:10 AM

I am looking for assistance in getting a formula to copy cell values between sheets if it matches criteria.

Scenario - sheet 2 will have shift schedules where cell will have vaues like 1, 2, 3 which are shifts and other values like Off which specify they are on off.. point to note is this will IST date format..

On sheet 1 we need to reflect the same values but the catch is the days vary due timezone difference... ex if person x has shift 1 for 9th june then it will 8th in est..

Overall if it is shift 3 it would on the same day but for shift 1 or 2 the cell value should for the next day which would be from the following cell in sheet 2.

Tried using if formula but not being successul. Any help would be appreciated.