Excel Magic Trick 1194


VLOOKUP: Data Mismatch Makes Yields #N/A, What To Do?

DESCRIPTION

See how convert Number lookup_value to Text Number and how to convert Text Number lookup_value to Number to VLOOKUP does not yield #N/A:
(00:08) Problem Setup: Data Mismatch Makes VLOOKUP yield NA Error
(00:43) Text Number Lookup Value won’t match against my column of Numbers for VLOOKUP: Use Any Math Operation on a Text Number that you want to convert back to a Number.
(01:33) Number Lookup Value won’t match against my column of Text Numbers for VLOOKUP: Use Ampersand (Join Symbol) and a Zero Length Text String (Double Quote, Double Quote) on Number that you want to convert to a Text Number.

WORKBOOKS




Be the first to comment

Leave a Reply