I have a named range that I would like to search and then pull up a different
value. It looks like this.....

OLD NEW ( the range is named salesreps )

333 1045
444 1040
555 1024
888 1010
999 1001
AAA 1022
DLB 1037
EEE 1010

=(VLOOKUP(Customer!E2,salesrep,2,1)) <-- on my spreadsheet

the function that I wrote will take all the Alphabetical stuff but not any
numbers... what am i doing wrong