Formula to get all combinations of two lists | Excel lambda 

Whoever is this miraculous lady, God Bless Her!

Oh mah gawd I had no idea this kind of power was possible. I was blown away seeing you could create variables, but then a Lambda function, too!?!? 🤯🤯

You are an awesome teacher Karina. Thank you

Wow, your brain is a beautiful thing. Thank you Karina!

Myself: Writing a VBA function. Other youtubers: Bother Power Query. Karina Adcock: Hold my ! and give me LAMBDA.

That's exactly what i've been looking for. Many thanks

Great example on how to perform a Cartesian joint. A bit more involved than doing it in Powerquery however i wanted to see an excel option using dynamic arrays. Thanks for posting this great video

My god, you're a goddamn legend Karina!!!!!

Wow, mind blown. Thank you.

This is pure genius!

What an amazing video!!!! Hats off to you. Cant thankyou enough for this!

Omg! life saver! exactly what i needed!

Can you please make a video to make such all combinations for 3 or more columns.

This is a great time saver! Thank you!

great video and to the point, saved me hours of googling :)

Wow, this is great. Thank you Karina, You have saved me lots of time for my report. can I be able to have three sets of data instead of two?

Awesome tutorial, YOu may need a lozenges btw.

Brilliant, thank you

Brilliant!

Incredible !

Bravissima! Grazie.

I REALLY....REALLY NEED HELP WITH MY SITUATION, PLEASE! I have combinations in multiple cell blocks. I need to add a selection of numbers to all cellblocks while maintaining the correct numerical order of the combination. For example: I have cell blocks containing such combinations as: 03 05 09....15 17 21...ect and I want to add 2 even numbers say 2 and 4. How can I add to cell blocks making them 02 03 04 05 09, ect ??? BIG thanx!

How do I use this if my array has blanks? it not working in that case?

Is it possible to learn this power... for Google Sheets?!

Does this work on google sheets, and can I use this to combine 3+ lists?

I am not able to copy the value produced. How can I copy?

i do =A1:A4 & D2# is not work

wow, genius

What.....?