Hi,

The solution in the attached file may trigger how to solve your problem
I used match and indirect function to locate the output.


Note in the demand I did do a ugly modification by substracting 1 else an exact match would give aincorrect output.

Hope this helps

4thangel

Thanks 4thangel, however there was no spreadsheet attached. Could you reattach it please.