Forum Discussion

MichielS340's avatar
MichielS340
Copper Contributor
May 14, 2025

Lambda map formula and spilled range

Hi, 

In the attached file I try to have one formula that takes a spilled range and based upon the value of a cell in the spilled range (compared to the cell one column to the left) I want to return a specific label (result in the yellow areas, the orange area tries to do the same but then in one spilled formula).

Somehow the results remain blanks.

Anyone any advice on the map formula that compares the cells?

Many thanks, 

 

Michiel 

Resources