I have the attached. The named range is a small version of what I actually use, but illustrates the point. I'll have many of these, and there are many more rows pertaining to a particular named range. Right now, for me to find the vertical spot column L needs to look at, I'm pointing (absolute reference) to a number, which I've generated with a simple row subtraction. What I'd really like is for the row number part of the hlookup, the hlookup has a function within it that basically says:
"look in column K...whatever is there, go find it in the range, and us that line as the line to return (for the appropriate hlooked up value across the top"
I'm thinking it's some sort of index or find, or combination.
Important because the number of items and the number of hard points I'm having to do is getting tedious. I need one named range (which is my assumptions area I'm asking someone to fill in, including additional potential items), and then the formulas do the rest of the work...meaning I can take a section of pivot list lines, and bulk copy them (basically what I did for the 'That item' lookup, simply changing the absolute pointer manually. When I have to create an additional 25 of them, it's more troubling to redo the absolute point. And reality is that there will be about 100 individually tracked assumptions, across various named ranges...so having a standard formula that does the legwork of looking horizontally AND vertically, to find the right spot, is key for efficiency.