I am not on the right version of excel. Having not long learned how to use VLOOKUP, from your demonstration, this XLOOKUP function looks great. Better than Vlookup for sure. Thank you for sharing. how do I think I will use it, well I use vlookup to compile data into one table from other sources and I could use xlookup for this instead.