If you enter formula in B2, then go to the lower right corner and double click, it will fill a continuous range. Useful for larger data sets.
This is a common cause of VLookup not working when pulling data from multiple sources together. Sometimes it can also be spaces you need to trim off.
Keep Up with TechRepublic