VLOOKUP & LEFT Functions
Download Excel File: https://excelisfun.net/files/EMT1627....
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.
