Hello all, how can i adjust this formula to also look for the year value in the column A of the same sheet and need to match it to the current year.
it needs to confirm both cases.
=IFERROR(IF(ISNA(VLOOKUP(I$2,INDIRECT("'"&TEXTBEFORE($A3," ",2)&"_data'!D:D"),1,FALSE)),AV3,"Yes"),AV3)
it needs to confirm both cases.
=IFERROR(IF(ISNA(VLOOKUP(I$2,INDIRECT("'"&TEXTBEFORE($A3," ",2)&"_data'!D:D"),1,FALSE)),AV3,"Yes"),AV3)