Cell mismatch - not sure why

[itsrich]

In my workbook I have two tabs

1. Database
   1. Column C = Vendor PN
   2. Column A looks up F100 = XLOOKUP(C3,Data!B:B,Data!A:A,"Not in DAX")
2. Data
   1. Column B is a list of Vendor PN copied and paste from a CSV pull from DAX
   2. Column A is the F100

Some cells on the Database Tab with the XLookUp fail to find match returning "Not in DAX".

Current Resolution: I search the number and find it on the Data tab and then copy it to the Database tab.

Also, when I click into the cell and hit enter, it also fixes the issue.

What else can I provide to help solve this? I don't wish to upload the entire file.

 

[RoryA]

At least you can turn off a lot of the conversions now, and get a warning about any that were made.

 

[itsrich]

The final result is that I crawled through all the spreadsheets and reformated all the cells. No quick way around this one. As always this forum has helped. TY all!