Hello all,
The below formula is pulling from a +1 column which is incorrect. The Index and first Match info are aligning. The second Match are dates as column headers with Y or N below. I tried putting the formula in a cell, removed the IFERROR function to ensure it wasn't an error and had the same issue. I'm not sure what I am overlooking so any help would be greatly appreciated.
.Range("F6:F" & Ordid).Formula = "=IFERROR(INDEX(Polling_Schedule!$B:$R," & _
"MATCH(Raw_Data!E6,Polling_Schedule!$B:$B,0)," & _
"MATCH(Raw_Data!$D$2,Polling_Schedule!$A$1:$R$1,0)),""N"")"
The below formula is pulling from a +1 column which is incorrect. The Index and first Match info are aligning. The second Match are dates as column headers with Y or N below. I tried putting the formula in a cell, removed the IFERROR function to ensure it wasn't an error and had the same issue. I'm not sure what I am overlooking so any help would be greatly appreciated.
.Range("F6:F" & Ordid).Formula = "=IFERROR(INDEX(Polling_Schedule!$B:$R," & _
"MATCH(Raw_Data!E6,Polling_Schedule!$B:$B,0)," & _
"MATCH(Raw_Data!$D$2,Polling_Schedule!$A$1:$R$1,0)),""N"")"