How to display certain text on an adjacent cell when it is a statutory holiday for a timesheet?
Solution 1:
You may try this,"to display the text STAT in an adjacent cell, if any of the cells on the column generates a Date that is a holiday from the list."
:Caveat:
Since you have not uploaded any sample data so that I've assumed Dates in Col T and Holidays in Col W.
-
Formula in cell U81:
=IFERROR(IF(LOOKUP(T$81:T$95,W$81:W$83,W$81:W$83)=T81,"STAT",""),"")
N.B.
-
You may replace Blank Spaces with an appropriate Text.
-
Adjust Date list, Holidays & Cell references in the formula as needed.