Oh, I encountered a problem while thinking about replacing all the
INDEX with direct references.
I see a lot of
- If I reference the cell directly, I’ll get very long/hard to read formulas:
- I won’t be able to refer to
Column + 1 as easily:
This is to reference either column C/D or E/F in the config, depending on some values present on the row itself. I tried making formulas simpler by breaking them down, but it’s still quite long with multiple IFs and SUM and ROUNDUP referencing data from the config.
I made a very basic demo to better illustrate. In
Data someone create a new row/line, and define the type, here it’s either 1 or 2. In
Result, we use the
value type as a way to get proper data related to it from the
Demo.ods (14.5 KB)
I arranged so the
Result sheet have it’s
B5 value where mine is for the row’s data type/class.
I hope I’m making myself clear and sorry I didn’t elaborate sooner, I thought this was going to be much simpler. Any tips?