Learn and Earn Answers:

1. I like this new xlookup. I think it is a great advancement. There are a lot of improvements over the existing vlookup. that makes it more functional than vlookup and its more versatile. I think it is way better than vlookup.
2. I have a number of tables where the requirement is to look to the left, or look down. I can now do both of these with the one function xlookup.

Thanks for the video. I had watched a few others, and you explained how to use xlookup very well. some people like to make it sound way more complex.