Forum Discussion

Chris_Gross's avatar
Chris_Gross
Icon for Microsoft rankMicrosoft
Dec 03, 2020

LAMBDA Examples: Distance between two cities

This post is the first of a series where we will be sharing out examples of lambdas. This is intended to highlight lambdas we have cooked up that show the power of this new super-charged function. Ad...
excel
Formulas and Functions
Sameer_Bhide's avatar
Sameer_Bhide
Iron Contributor
Dec 09, 2020

Chris_Gross 

 

CellColor

=LAMBDA(Rng, GET.CELL(63,Rng))

Crashes excel

Any way to get this to work

 

Cheers

Sam

  • David Hager's avatar
    David Hager
    Copper Contributor
    Dec 10, 2020

    Sameer_Bhide No. XLM functions cannot be used on the worksheet.

Resources