Search Results for: vlookup

Google announced Named Functions and 9 other new functions on 24th August 2022. The biggest news here is the new feature called Named Functions. Named Functions let you save and name your own custom formulas, built with regular Sheets functions, and then re-use them in other Google Sheet files. It’s a HUGE step toward making … Continue reading New Functions In Google Sheets For 2022: Named Functions, Lambda, MAP, REDUCE, etc.

The CHOOSE Function in Google Sheets lets you choose between different options. It’s a lookup function, akin to a limited VLOOKUP rather than an alternative to the IF function. It takes an index number and returns a value at that numbered position from the list of possible options. Here’s a simple example: =CHOOSE(1,”A”,”B”) which will … Continue reading How To Use The Choose Function In Google Sheets