#N/A-error

#N/A i.e.”not available” when Excel cannot find a lookup value. There are few specific reasons due to which VLookup #N/A error shown.