Nested VLOOKUPS with a searched, moving range

It would help if you attached a sample Excel workbook, so we can see how your data is laid out.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Hope this helps.

Pete

I ended up figuring this out. Sorry I wasn't able to come back to share data. It would have taken my hours to scrub it to be able to share it. I know my quick example wasn't super informative.

In case anyone runs into something similar:

I was basically doing 2 references (nested VLOOKUPs). The first line looked for a search key but needed to not only return the first time it was found but also the last time it was found. The second lookup then searched that range.

So the range of the outermost VLOOKUP needed to move based on another search.

I ended up using INDIRECT to build the moving reference range using MATCH. It's setup to search for the first and last time a search key is found which becomes the start and end of the outermost VLOOKUP.

In my case, if it wasn't found in the first index, an IFERROR was used to find it in the second. But that part is super specific to my data. I can't image anyone else using that.

Thanks for telling us how you solved it (and for the rep).

Pete