Hi all,

Wow, thanks so much for all the replies! Very much appreciated.

@shg - this solves the problem exactly, thanks so much. I didn't realise that you could use relative reference in named ranges which would be relative to where the named range is called (seems kinda obvious now). Thanks again!

@bentleybob - I tried playing around with your suggestion but the cell function evaluates based on the cell that's selected at the time of calculation, *not* based on the cell where the named range is called.

@broro183 - vlookup isn't an option for my particular problem, meaning this is a small piece of a bigger question and rearranging my data to make vlookup happy isn't really possible, but thanks for the suggestion.

Thank you all! Not sure exactly how to mark this [solved]...

Keith