The problem almost always lies in a format mismatch: in one table, the date is a real data type, while in another, it’s just text. For VLOOKUP, these are different values, so it returns #N/A.

The first method is to quickly convert text to a date using the "Text to Columns" tool on the "Data" tab. The second is to use the TEXT() function inside VLOOKUP to convert the lookup date to a text format matching the source array.

If the data is too "mixed," consider an alternative to VLOOKUP. For example, the XLOOKUP function handles searching across different data types better, and a detailed comparison of XLOOKUP and VLOOKUP will help you choose the right tool.

🔗 Source: excel.rf