I have the following instance:

Cells C8:C12 which I am having issues with and columns AE:AI which contain
my information :
in C8 I have used validation to create a dropdown list of names
in C9 I have the following formula:
=IF(C8="","",IF(ISNA(VLOOKUP(C8,timecard,2,0)),"No
Match",VLOOKUP(C8,timecard,2,0)))

Once I get to a certain point in column AE (specifically row 99) I get "No
Match" for my function answer.

Please advise.