Can you share some examples of XLOOKUP formulas? I’ve used VLOOKUP in Excel my whole career, but I want to switch to XLOOKUP as part of upgrading my spreadsheets to Row Zero. I’ve heard XLOOKUP is the modern version of VLOOKUP and is better.
Here’s a tutorial for how to use XLOOKUP along with XLOOKUP examples. As mentioned, XLOOKUP is better than VLOOKUP in all use cases.
You can also view live XLOOKUP examples in a spreadsheet here so you can see exactly how it works. Here’s the first XLOOKUP example in the spreadsheet:
While we recommend using XLOOKUP instead of VLOOKUP, Row Zero continues to support VLOOKUP so that folks can import XLSX files into Row Zero that contain VLOOKUP formulas. Here’s a breakdown of XLOOKUP vs VLOOKUP if you’re interested.