Using: using Microsoft® Excel® for Microsoft 365 MSO (Version 2111 Build 16.0.14701.20240) 32-bit
I cannot get this formula to work, I get an N/A in the field. I have created a calendar on another worksheet, sample below.
Any help would be greatly appreciated.
Formula in Column F: =MATCH(E6,'16x5 Calendar'!C$4:C$3000,0)+(MATCH(E6,'16x5 Calendar'!C$4:C$3000,0)=MATCH(E6,'16x5 Calendar'!D$4:D$3000,0))
I cannot get this formula to work, I get an N/A in the field. I have created a calendar on another worksheet, sample below.
Any help would be greatly appreciated.
Formula in Column F: =MATCH(E6,'16x5 Calendar'!C$4:C$3000,0)+(MATCH(E6,'16x5 Calendar'!C$4:C$3000,0)=MATCH(E6,'16x5 Calendar'!D$4:D$3000,0))
Last edited by a moderator: