sam__gleeson
Board Regular
- Joined
- Oct 11, 2012
- Messages
- 102
Hi
Formula needed in sheet "Performance" D21 .... will drag formula across to Z21
Sheet "Performance" C21 = Work Hours - Days
Sheet "Performance" D20 = Date
Sheet "Main" C5 = Todays() Date
Sheet "Main" B6 = Work Hours - Days
Sheet "Main" C6 = 8
I need D21 to look at "Performance" D20 date and match it to Main" C5 = Date + "Performance" C21 = Work Hours - Days to match "Main" B6 = Work Hours - Days and if they all match place the number in "Main" C6 into "Performance" D21
I get it to work except when the date changes to the next day it wipes out all previous numbers...is it possible that when a number is entered in D21:Z21 that the number remains there even when the date advances daily
Thanks
Formula needed in sheet "Performance" D21 .... will drag formula across to Z21
Sheet "Performance" C21 = Work Hours - Days
Sheet "Performance" D20 = Date
Sheet "Main" C5 = Todays() Date
Sheet "Main" B6 = Work Hours - Days
Sheet "Main" C6 = 8
I need D21 to look at "Performance" D20 date and match it to Main" C5 = Date + "Performance" C21 = Work Hours - Days to match "Main" B6 = Work Hours - Days and if they all match place the number in "Main" C6 into "Performance" D21
I get it to work except when the date changes to the next day it wipes out all previous numbers...is it possible that when a number is entered in D21:Z21 that the number remains there even when the date advances daily
Code:
=IFERROR(INDEX(MAIN!$B$5:$C$8,MATCH($C21,MAIN!$B$5:$B$8,0),MATCH(D$20,MAIN!$C$4:$C$8,0)),0)
Thanks
Last edited: