Hi Domenic,

I am now getting most of the expected ID results. However, I still have a
problem returning the correct ID result where zero "0" EmptyText rows needs
to be matched.

It looks like you'll have to adjust the references for the other defined
names which refer to Data. So, for example, if the first cell in which
the formula will be entered is BA7, first define the name Range as
follows...

=INDEX(Data,0,ROWS($BA$7:BA7))

Then replace any reference to Data or 'Site Lond'!Data with Range. See
if this helps.

This has helped.

Further help appreciated.

Cheers,
Sam

--
Message posted via http://www.officekb.com