I am trying to write a formula where if there is no information in the first column, then look to the next column to see if there is anything there, if something is found then execute the formula. I have managed to get it working for two columns, however not sure if that is the limitations with the formula I'm using.
This will remedy that part. Embed it in your formula where needed and you will not have to check each column separately. Try 'demoing' it in Z3 and fill down.Then try in AA3 That will return the first number. Then this in AB3 That will return the 'L#.#' headers.
I haven't examined the rest of your formula thoroughly. I couldn't help noticing the relative cell/range references. It appears you are hand typing each formula in each row. You can save yourself a lot of grief and work if you get acquainted with relative/absolute cell referencing. (That's what the $ signs are about.)
With that thought in mind I encourage you to read up here: Relative and Absolute Cell References
Does any of this help?
Bookmarks