Thread: VLookup Errors
View Single Post
  #2   Report Post  
Rob
 
Posts: n/a
Default

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?