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!