LAMBDA Function and Using Cell Values as Ranges

[chuckjitsu]

Hello. I've been playing around with LAMBDA via 365. I came up with the below, which checks two ranges to see if they intersect. In this particular case with the used parameter values, this resolves to True, meaning no intersect.
No problem there. Now let's say cell A1 contains the value for x, in this case the text A1:E1. What syntax would I use so that the x value below in the second function would refer to the value in cell A1, in this case A1:E1, not the address of A1? Basically, x needs to be populated with a cell value, not a cell address.


=LAMBDA(x,y,ISERROR(x y))(A1:E1,C2:C13)

=LAMBDA(x,y,ISERROR(x y))

 

[chuckjitsu]

Well, I'd been doing all my Lambda testing in the same worksheet, so I decided to create a fresh worksheet and that did the trick. Not sure why I was getting those 0 values in one worksheet and the correct values in another, but it does work, so thanks again!

 

[Fluff]

Glad it's sorted & thanks for the feedback.

 

[chuckjitsu]

I don't want to take up too much more of your time on this, but can you briefly explain what you did to correct the formula? I like to add to my Excel knowledge as I can.

 

[Fluff]

I didn't change anything, you said you created a new sheet & it worked.