I'm so happy they didn't take too long to bring this to Google sheets!

Amazing, thank you so much for sharing all things. My wife have a small business, she need “a software” to manage all the bill, stock, customers, staff, deliver … I created a “software” to solve all her need. And your channel helped me so much to do all of that. Thank you so much !!!! ❤❤❤ A big thanks from Vietnam ❤

Fantastic tutorial thank you. I hadn’t even realised that Lambda had been added to Google Sheets. This is certain to be really useful. 👌🏻

This is most precious day for me after watching this magical video You are the wonder in the world for me Lot of love ❤

THANK YOU, THANK YOU, THANK YOU. The way you explain things that even a one-year old can understand is just incredible. And this definitely will become one of my top formulae. So much potential!

After watching this video, one realizes how powerful spreadsheets have becomes since Lotus 123. Thanks.

Finally LAMBDA became clear! Thanks a lot

I was wodering when you were going to cover this for Google Sheets. Thanks for the video

Quá tuyệt vời. Nhờ video mà tôi hoàn thiện và hiểu sâu hơn về cách kết tạo hàm mới kết hợp Lambda. Cảm ởn rất nhiều.😍

Very cool, and very helpful. Thanks!

Excellent tutorial as always. Thank you! ❤️❤️❤️

You busted my fer for Lamdas! God bless you 🙏

Brilliant explanation. I love your tutorials 😍😍

This is great. Thank you so much!!

Stupendous!

Can't wait for you to cover all the lambda and its derivatives functions!!

Yessss so excited for this! Thank you!

Nice video/tutorial! Their are functions I keep forgetting and just made one: LAST_CELL_VALUE. index(L54:L,Match(100^100,L54:L) where the column is named Range . Doesn't seem like much but it is easier for me to remember this way. Thanks a bunch and I would like to see more strung together and odd ball functions.

👍🏻 Excellent explanation, thanks. Can't wait to try this on my android! UPDATE: Nope, Google has withheld the definition of Named Ranges and Named Functions .. _from its android app users!_ 😢😡 Let's go Gurgle

This video, a masterclass in story telling😭. This video had better payoff than Lord of the Rings. Brought me to tears when he named the function MLOOKUP(world-shattered). This is my favorite video of the 2024

In Google Sheets, you don't need to use Lambda in the Formula Definition box. You could have just put everything after IFERROR and deleted the last parenthetical.

Thanks a lot

Thank you so much for this video. Please is there a way to wrap this MLOOKUP() into an array formula so that the LOOKUP_VALUE can be an array instead of just a cell? For example: =ArrayFormula(MLOOKUP(A2:A28, tisue!C2:C44,tisue!B2:B44)) This populates across the row instead of a column. = LAMBDA(lookup_value, lookup_array, return_array, TEXTJOIN("; " , TRUE, FILTER(return_array, lookup_array = lookup_value)))(lookup_value, lookup_array, return_array) Please help!

Great tutorial. Thank you very much

Sir, as some new functions has been added into Google Sheets, is there any work around for using Arrayformula with Textjoin or Index function to get rid of the dragging formula down like the case in this video?

Could you get lambda functions to work with ArrayFormula? I don't think they do.. 😞

Will they work when you download as excel sheet?

Yep

Hi, can you pease help me with an ARRAYFORMULA of this formula ? I know you mentioned already in comments using MAP but still can't figure it out.

Nice

Please cover Scan, sortn function in google sheets

I'm surprised at how much Google Sheets is like Microsoft Excel.

Is there any playlist for all the new functions released ?

Hi, am using office 365 and MLOOKUP formula not available in my excel workbook/sheet. how to get it

you cant use lambda if you're not sure if everyone you're working with has some of the latest versions of excel.