OK, glad to hear it, and thanks for feeding back.

Pete

On Jul 31, 11:13*am, E wrote:
Sorry, I fixed my second problem. :-)



"E" wrote:
That seems to work fine. I have never used INDIRECT before. Many thanks for
your help.
However, when I have a zero in B24 sometimes it returns 0 and sometimes
REF#! - do you have any idea why?