I am doing a VLookup from one sheet to another matching up rep codes -
everything is formatted as General. Our rep codes are either 2 numbers or 2
letters. The letters are working great but rep codes that are numbers return
as N/A.

Any idea how to fix that without changing the formatting?