Xlookup replaced VLOOKUP because it's simpler - here's how it works
This tutorial is showing how to use XLOOKUP to look to the left and to the right of the column containing your value.
This tutorial is showing how to use XLOOKUP to look to the left and to the right of the column containing your value.