I read the XLOOKUP vs VLOOKUP post and have switched from VLOOKUP to XLOOKUP. XLOOKUP is way better than VLOOKUP and is a lot more flexible. But I’m curious, are there any situations where VLOOKUP is still better?
I don’t think there are any scenarios where it makes sense to use VLOOKUP instead of XLOOKUP. Here’s a video where we break down the difference between XLOOKUP vs VLOOKUP and show examples of why XLOOKUP is better
And here are several XLOOKUP examples if you need help getting started or with specific scenarios.