Are Row Zero functions the same as Excel functions?

General Discussion Excel
1

I see Row Zero has the same functions as Excel like COUNTIF, VLOOKUP, etc. Do they work the same way?

2

Yes Row Zero uses the same formula syntax as Excel and Google Sheets so functions are generally compatible across all three spreadsheets. Row Zero has nearly 250 spreadsheet functions, including the most popular functions in Excel and Google Sheets. Each spreadsheet also has some unique functions not offered by the others.

4

Does Row Zero have the XLOOKUP function? I’ve started using XLOOKUP instead of VLOOKUP in Excel.

5

Yes Row Zero has the XLOOKUP function. You may also be interested in MULTILOOKUP, which works like XLOOKUP but allows for multiple conditions.