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.??
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.