I have a few folks using MS 365 E3 with the latest version 2202 (Build 14931.20120) Current Channel and when I use the xlookup formula it shows it as .xlfn in the formula bar when they open it up. That means that their version of Excel does not support that formula. IT has assured me they have the latest version of Excel so I am at a loss of what to do. I am using Version 2108 (Build 14326.20784) Semi-Annual Enterprise Channel. Anyone have any ideas on what I need to do? IT Could be wrong and they don't have the latest?
