Erika,
I'm guessing that vookup isn't sorted numerically and therefore you'll need
to use FALSE as the 3rd argument of Vlookup eg. =VLOOKUP(A1,A1:B100,2,FALSE)
HTH Rob
"Erika" wrote in message
...
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?
|