Can you go over the differences between VLookup and XLookup?

Answer 1

VLookup is used on a table of data where your known variable is in the first column and the value you're searching for is in a column to the right, but always in the same row.

XLookup is useful where you are looking for data that is in a column to the left of the known variable.

If you want a video going over these differences feel free to look at my profile and I have a recorded session going over the 2 formulas and how to compute them both!