vlookup with numeric and alphanumeric identifiers in lookup_value

[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.

 

[Elkar]

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