Forum Discussion
multi variable lookup across numerous ranges
In the attached, I'm looking for the red/white cell to do the following: 1) based on the selection in H16 (Customer Selection), look across the top until it find that range of assumptions 2) bas...
SergeiBaklan, my apologies for a long absence. I got hit with a string of personal issues (deaths, broken limbs) in my immediate circle, and fell off completely from this project. Back now, trying to get a handle on things again. Could I ask of you to walk me through the basic flow of the formula, and what it evaluates? I just want to make sure I'm clear on what the core blocks of it are doing. Thanks so much for any clarification on order and logic.
boriss321 , sorry to hear that, hope all your issues are in the past.
Sure, I'll update with details, most probably tomorrow.
Good luck.