does the name in B2 alread exist in column a?
if it does not the answer #na is correct
or should your lookup range really be $A$2:$B$288
"Inspector" wrote:

Column A = ID numbers
Column B = Names
Row 1 = Column headings

Formula in A2: =IF(B2="","",VLOOKUP(B2,'Tally Sheet'!$A$2:$B$288,1,FALSE))

Result is #N/A

Can someone tell me what I have incorrect and help with repair?

Thank you!