vlookup with numeric and alphanumeric identifiers in lookup_value

  • Thread starter Thread starter AML216
  • Start date Start date
A

AML216

I am trying to merge two worksheets in the same workbook. The common field
(a2) has both numeric-only (123456) and alphanumeric (AML456) entries. In
both worksheets, the fields are in text format. When I do a vlookup using
this field as the lookup_value, it merges the alphanumeric rows but not the
numeric rows.
 
You could either pre-format cell A2 as text, or try using the TEXT function
in your VLOOKUP to convert A2 to text. Like this:

=VLOOKUP(TEXT(A2,"@"),YourRange,2,FALSE)

HTH
Elkar
 
Back
Top