Hi Ford,

I did initially use the vlookup but the master file is huge and it takes 20-30 minutes to get the data displayed once the ID number cell is populated.