Error Solution Correct the typo in the syntax and retry the formulaError may occur in VLOOKUP in following cases In case if you misspelled the function's name in the formula The supplied col_index_num is not recognised as number in formula The suppliedThe Excel IFNA function is a logical function that returns the value specified if the expression resolves to #N/A, otherwise it returns the result of the expressionExcel Formula Training Formulas are the key to getting things done in Excel In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX
8 Excel Error Messages You Re Sick Of Seeing And How To Fix Them