Hi Niek

Yes, this works fine. Within each table for the lookup, there will be upto
30 rows of data, not several hundred, so I don't think that the speed will
be an issue. There will, however, be many (perhaps 200+) separate tables as
named ranges and I doubt that the VLOOKUP will be slow in this case as it is
looking at a specific named range of upto 30 rows, rather than looking at
each of the tables in sequence and then down each of the rows to find the
data. Is this argument logical? If so, I'm happy, otherwise I may have to
consider some other solution. The data *will* be found by VLOOKUP as I'm
using the first column for data validation when I'm entering the data in the
first place.

Thanks again for your time.

"Niek Otten" wrote in message
...
< I think because it passes the point in the list it expects to find the
answer

No. With th 4th argument set to FALSE, the list doesn't have to be sorted,
but is read sequentially from beginning to end (if the enry can't be
found). One consequence is that such a search is considerably slower,
which you can notice if you have hundreds or thousands of such VLOOKUPs.

--
Kind regards,

Niek Otten

Microsoft MVP - Excel