Hi,
I need help to integrate the INDEX formula in this LET function correctly.
I want the Index to return values based upon references of my columns, not based upon which number the row/column has.
This means that I can add/remove as many columns as I want and the formula will still look in the correct column.
Now, for example, If I remove the column 'O', the formula changes and is not displaying what it should because the columns are hard coded in the very end of the formula.
Attached spreadsheet.
Regards
Bookmarks