Excel Lambda and Let Function with Tom Hanks - Episode 2397

Microsoft Excel Tutorial: Using LAMBDA and LET functions in Excel.

Welcome to episode 2397 of the MrExcel Podcast, where we dive into the world of Excel and explore its latest features. In this episode, we will be discussing the LAMBDA and LET functions, which have been making waves in the Excel community. These functions allow you to return pictures from data types, making your spreadsheets more visually appealing and dynamic.

I was inspired to create this episode after reading about LAMBDA and LET in one of the Excel hash entries. These functions are relatively new to Excel and have been generating a lot of buzz. So, I decided to explore them further and share my findings with all of you. In this video, we will be using the example of Tom Hanks and his movies to demonstrate the power of LAMBDA and LET.

In the spreadsheet, I have set up two dropdowns where you can choose a movie from the Wolfram Alpha data types. These dropdowns are linked to a LAMBDA function called InBothCasts, which is where all the magic happens. Inside this function, we use the LET function to define two variables, Cast-One and Cast-Two, which contain a list of all the people in the chosen movies. We then use an XMATCH function to check if Tom Hanks is present in both lists. This is just one of the many things you can do with LAMBDA and LET.

But that's not all, we also use the FILTER function to extract a list of people who are in both casts. And here's where the real fun begins - we use the matching cast dot image and matching cast dot name to return the photos and names of these actors. This is a great way to add visual elements to your spreadsheet and make it more engaging. And if you're wondering what happens if a person doesn't have a photo on Wikipedia, don't worry, we have a solution for that too. We use the IFERROR function to display their name instead.

This is just one example of how you can use LAMBDA and LET in your spreadsheets. I have also included a link to the Excel file used in this video in the description below, so you can try it out for yourself. And if you want to learn more about Excel and its latest features, check out my new book, MrExcel 2021, Unmasking Excel. You can find the link in the top right-hand corner of this video.

If you enjoyed this video, please don't forget to like, subscribe, and ring that bell to stay updated with our latest episodes. We recently hit 100,000 subscribers, and we are grateful to each and every one of you for your support. If you have any questions or comments, feel free to leave them in the comment section below. Thank you for tuning in, and we'll see you in the next episode of the MrExcel Podcast.

This video answers these common search terms:
how to make a lambda function on excel
what is a lambda function in excel
what is lambda function in excel
how to create lambda function excel
how to use lambda in excel
excel how to use lambda
how do i use excel's lambda function.
how to use let function in excel
how to use let funtion in excel
how to use let in excel
how to write let excel formula
how to use the let function in excel

Table of Contents
(0:00) Problem Statement: LET and LAMBDA in Excel
(0:40) Finding actors in both movies
(1:10) Using XMATCH with IFNA
(1:46) FILTER function in Excel
(2:04) Getting images of actors
(2:43) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial

This video answers these common search terms:
how do i use excel's lambda function.
how to create lambda function excel
how to make a lambda function on excel
excel how to use lambda
how to use lambda in excel
what is a lambda function in excel
what is lambda function in excel

Microsoft Excel has two new formula functions.
Here is a cool example of a LAMBDA function with a LET and XMATCH function. Point to two cells that contain movie names and the function will find the cast who is in common between the two movies and provides the photo of those people in common.

[excelisfun]

Thanks for the movie LAMBDA and LET fun, Mr Excel!!!!

[wayneedmondson]

Nice one Mr. Excel! Interesting and clever use of Data Types, LET and LAMBDA. Thanks for sharing :)) Thumbs up!!

[AnandPenmatcha]

Congratulations on achieving 100K subscribers

[jimfitch]

This would have been very useful a decade ago when the Kevin Bacon Factor was the rage: start with 2 actors who have never acted together in a movie, then how many movies with Kevin Bacon does it take to connect the starting 2 actors? I think the biggest # I ever saw was 3. My kids (now in their 30s) killed me every time. I coulda used Wolfram, LET, & LAMBDA to level the playing field. They still would have won (one of us was working full time, four of us were watching a lot more movies — or remembering better what they watched — than the other), but it wouldn’t have been so lopsided!

[Officeinstructor]

Very Cool tutorial. Lots of new functionality in there. Thanks for sharing.
Will get the book now.
Order #132161639

[sanjaybaraik]

I need help sir.

Condition- service fee bracket
Rs.2.5 per Rs.1000( Min charges Rs.35 and Max 200)
Eg.

Irrespective of change amount from min charges 35 and max 200.
How to make such calculator in excel. Please help