After years of waiting, Google Sheets finally supports the powerful XLOOKUP function, and has added other powerful new functions too.

Google is updating its Bard AI chatbot to support code generation. Developers can now use Bard to generate code, debug existing code, and help explain lines of code.

You can use VLOOKUP with Google Sheets similar to how the search function is used to find information in Excel.