Erika,
That formula looks correct and should work regardless of whether number of
text. If it isn't working, are the numbers in the range to lookup actually
numbers i.e. could they have been imported an are in fact text but look like
a number?

Rob
"Erika" wrote in message
...
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?