Dear Community,
I am trying to have an automatic filling of the column [Budget Max] while changing the column [Level]
based on 2 other columns references: [Level attribution] and [Max Budget Range] with matching ROWS.
If [Level]value = [Level attribution]value return [Max Budget Range]value of the same ROW of [Level attribution]matchingvalue.
This Formula works, but only for one row, while I would like it to work for the all sheet:
=IF(Level@row = [Level attribution]1, [Max Budget Range]1)
I have tried other possibilities below, but all of them returns either #Invalid Column Value or #Unparseable or # Incorrect Argument Set...
=COLLECT([Max Budget Range]1:[Max Budget Range]5, [Level attribution]1:[Level attribution]5, Level@row)
=IF([Level attribution]1:[Level attribution]5 = Level8, [Max Budget Range]@cell, "-")
=IF(Level@row = COLLECT([Level attribution]:[Level attribution], [Max Budget Range]:[Max Budget Range]))
Any suggestion would be of great help, thx!
