Thanks Ward. Problem wound up being that new entries pushed beyond a named
range in the source table that I hadn't seen earlier. once I extended the
range, all was well.

thanks again.

"ward376" wrote:

I checked the format of the cells that don't respond to lookup

You need to match up the actual data type of the data in the cells -
do your downloaded lookup values contain only numbers?

Cliff Edwards