Error value usually means that the formula is missing quotes To look up a person's name, make sure you use quotes around the name in the formula For example, enter the name as "Fontana" in =VLOOKUP("Fontana",B2E7,2,FALSE)The top reason why the #NAME?Errors occur if you type the word VLOOKUP wrong (C14 below) or if you don't use quotes when Excel expects it (in C15 below we need to use quotes " " around the Adrian word) This applies when you are referring to a particular text item
Understanding Excel S Name Error Youtube