I have a nested IF statement with a VLOOKUP that seems to have stopped working. For debugging, I've stripped out all but the VLOOKUP function and made the search value static, "DSHS". Formula: =VLOOKUP("DSHS", [Agency & Administration]23:[Agency-Div Sort Order]24, 22, false) "Agency & Administration" is the Primary Column…
HI there, So I have a reference sheet, listing down all Australian Public Holidays by State (multiple drow-down). What I would like to do is to identify these holidays in my Destination sheet, and display if the holiday is either QLD, VIC or NSW or all three. I am currently using a helper column to identify if the dates…