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