Make the last parameter of the VLOOKUP function 0 instead of 1 - then
it will look for an exact match.

Hope this helps.

Pete


On May 8, 11:56 pm, Noncentz303
wrote:
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