VLOOKUP & LEFT Functions #N|A Error. And Lookup Code is in List?!? Excel Magic Trick 1627

Download Excel File:

See what to do if the LEFT Function correctly extracts a Number Code for the VLOOKUP function Lookup Value, but you get an #N/A Error. Learn that Text Numbers and not the same as Numbers. Learn how to perform Math Operations on Text Numbers to convert them back to Actual Numbers that can work in the VLOOKUP Function. Also see the reverse: how to convert an Actual Number to a Text Number.

Excel,Highline College,Mike Girvin,excelisfun,excel is fun,EMT,EMT 1622,Excel Magic Trick 1622,excel formula,formulas and functions,excel functions,VLOOKUP,LEFT Function,VLOOKUP #N/A Error,NA Error in VLOOKUP,VLOOKUP Error,VLOOKUP and LEFT Functions #N/A error,Lookup #N/A,Text Numbers,Numbers or Text Numbers,Excel Text Numbers Error,Extract Lookup Value for VLOOKUP,Math Operation to convert Text Number to Number,