Rob,

Here is my formula looks like

=VLOOKUP(A5,Dailyfile!$A$1:$D$323,4,FALSE)

Is that correct?

"Rob" wrote:

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?