Reasons for Vlookup #name? error
#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. If you have a named ranged called adrian then this would work.