The error probably has to do with the reference for the appropriate
range within your named range 'Data', which spans a number of rows and
columns. So you'll need to replace the named range 'Data' in my
formula, which just refers to a single column, with the appropriate
reference for your worksheet.

You had mention that you will be copying the formula down the column.
If you want to pick up an new column each time the formula is copied to
the next cell below, I think you'll need to replace 'Data' in my formula
with INDEX(Data,0,ROWS(BA$7:BA7)). If, however, you want to pick up a
new column each time the formula is copied across instead of down,
replace 'Data' with INDEX(Data,0,COLUMNS($BA7:BA7)).

Does this help?

In article <790f6dd708df7@uwe, "Sam via OfficeKB.com" <u4102@uwe
wrote:

Hi Domenic,

Thanks for sample file.

If I try to match zero (0) EmptyText rows Formula returns #REF! error.

Also range "Data" is dynamic with many rows and columns. ID is a single
column dynamic range.

Further help appreciated.

Cheers,
Sam