Question Regarding XLookup/Numbers Stored as Text

Hoping someone can provide some insight...might be an easy answer but I haven't encountered a lot of number stored as text issues before.   Basically I'm working on a spreadsheet that has identifie...