Lookups and Offsets

[wmjenner]

I would like to take a previous issue to the next level of complexity.
Here's the scenario

 

[Ken Wright]

Here's a possible solution