The #N/A result indicates that the name you're looking up doesn't exist in
your lookup range. If you are certain that the name does exist, check for
things such as leading or trailing spaces around the name. Excel will not
match " USPS" or "USPS " with "USPS", and it isn't evident by glancing at
your text entries whether they have extra spaces.

Duke

"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!