I am trying to return a value based on matching dates that have AM/PM. I have tried Index/Match & ArrayFormula & VLookup Formulas that all should have worked to bring in the value that I'm looking for but each time I get "Did not find value '44972.75'" or similar depending on the row. here is the formula
=if($A6<>"",INDEX('On-site Totes Pilot'!$E:$E,MATCH($A6,'On-site Totes Pilot'!$O:$O,0)),"")
Cell A6 Has 2/15/2023 PM in it.
And the Range 'On-site Totes Pilot'!$E:$E also has 2/15/2023 PM in it.
I understand that Google Sheets converts dates to a number but What can I do to make Date 44972.75 match?
Here is a link to a test doc to play with https://docs.google.com/spreadsheets/d/1yDc1fXIH_S6WxsqFGHi9VUW_d4V5aTeaT7fv5c_xR1c/edit?usp=sharing