XLOOKUP returning #N/A

[onthegreen03]

I am using a simple XLOOKUP function and it is returning #N/A. I think the reason is that the lookup value is a formula (referencing a date) and the lookup array is also a formula referencing dates from a different location. I am guessing it some sort of format issue because when I remove the formulas and value the dates the XLOOKUP works. In my case, the lookup value is Jan-25 and I am referencing a lookup array that has data from Jan-25 through Dec-25. I am returning data from a specific row that matches Jan-25. I checked to make sure the cell formats are the same in date cells, and they are.

Is there a way to set up a XLOOKUP to ignore the formula/format and just match the values that both formulas return? Seems like there is way around this but I can't for the life of me figure it out. Thanks for the help!

 

[onthegreen03]

Never mind, I figured it out. I simply converted the values to TEXT and it worked. All good.