Matching Dates

[M0X3]

I keep having the same issue matching dates using MATCH, HLOOKUP, or VLOOKUP. I use TODAY() or DATE() functions to input the dates into my functions and I checked the dates that I'm trying to match to aren't text. Yet I keep getting #N/A when I look through the specified array. I've had a similar problem in the past but it was fixed when I set the LOOKUP functions to "EXACT" matches. This time that didn't work...

 

[Joe4]

It could be a formula issue or a data issue. Note that if any of the dates have time components, even in they are hidden, will cause records not to match.

It is hard to say exactly what the issue is without being able to see the data you are working with and formulas you are trying.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[M0X3]

Thanks for the reply! I ended up working around the problem since I wasn't able to share a copy of my excel.