Quote: First off let me point out that the above is really no different to your earlier formula just shortened slightly and lookup range reduced to A:E given you're returning value from E you need not reference anything beyond that.

I have an extended range because the cell below this one references from 7, below that from 9 etc until 19....

thanks for the concern though