Here are my results, the provided formula returns, #N/A.
This is what I am trying to accomplish.
If a cell has the date, 1 Jan 2009, I need it to reference a table to see if that date matches a date in column A, and then return the value (text) related to the date in column B. The table contains 11 dates and corresponding holiday names.
So, if C1(1 jan 09) = B1:B11(dates of holidays) then return the value in A1:A11 (names of holidays) otherwise leave blank
Hi, one glitch. If no value is available to be returned, "#N/A" is returned. Is there a way to leave the cell blank if no value is available to return. In other words if the date being referenced does not match the holiday date list, leave the cell blank.??