In fact OFFSET and INDIRECT being voltaile functions, I don't like to use them.
In this case the use of INDEX might be better but I haven't got XL on my Linux machine to test it

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thanks guys. It appears the INDIRECT function is best suited for this. Most of my reference are nested if statements, thus the INDEX function just makes the formula longer and more confusing.