Hi All,

I have a database on sheet 1 and a table on sheet 2.

In column A on sheet 2 i have names and im trying to formulate a VLOOKUP that will deliver the word that is column 13 in the database on sheet 1 to the table in sheet 2, once the names match.

=VLOOKUP(A5,Sheet1!1:65536,13,FALSE)

thats what i have but i keep getting a #NA

Any help will be greatly appreciated!