Hi Christine,

Thanks for the response.

Wouldn't I have to still increase the named range? I'd have to specify the
range of the named range and if that included blanks, would it confuse the
lookup (which seems to be easily confused *grin*).

Cheers!

" wrote:

Could you apply names to the table-array in the lookup function? Then
you could just increase the named range and not have to update any of
the lookups...