I have an XML file that I have imported into my worksheet with several columns of data. I am wanting to search out values based upon entering a date and displaying the data in a corresponding row. I have no problem writing the index/match formula to look up the data, yet have been running in a "N/A" error. Here's what happens. When I enter the date to be referenced, the formula returns the error. Yet if I then go to data page, delete the date and then enter the same date in manually, the formula returns the desired data. I've messed around with formatting and clearing all formats, yet still run into the same problem. I know my fix is easy to just go to the data and re-enter it all manually, but I have over 3k rows of dates so not really a good use of time. Does anyone know how I can fix this?

Thank you,
Nathan