VLOOKUP Errors with Numerical and Alphanumerical Data

=VLOOKUP(lookup_value,table_arrycol_index_num,range_lookup)

If the lookup_value data contains a mix of numeric and alphanumeric values, the formula is likely to give a #N/A result.

If this is the case, use Excel’s Text to Columns (Data tab) function, leaving the delimiter TAB option enabled.

 

---