Apps Script Equivalent of Google Sheets Functions

Hi everyone,

I spent many hours creating a new page where I've listed numerous Google Sheets functions and their equivalents in Apps Script to help those who are not necessarily very comfortable with this language (which, by the way, is much more advanced and practical than VBA, as it is a recent version of JavaScript benefiting from many features and concepts of modern programming languages).

Here are 2 examples to better understand...

MATCH

The Google Sheets function:

=MATCH("Sheets",{"Excel";"Google";"Sheets";"Pratique"},0)

Its Apps Script equivalent:

['Excel', 'Google', 'Sheets', 'Pratique'].indexOf('Sheets');

MAP

The Google Sheets function:

=MAP({10;20;30},LAMBDA(value,value+5))

Its Apps Script equivalent:

[10, 20, 30].map(value = value + 5);

More Examples

The other examples are here:

https://www.sheets-pratique.com/en/codes/google-sheets-apps-script-functions

I hope this will help some of you (if you have any questions, don't hesitate)