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.
--
AML, Wilmington, DE