YEEESSSS Thanks for the big helps guys

shepard that statement:
=IF(ISERROR(VLOOKUP(Customer!E2*1,salesrep,2,FALSE ))=TRUE,VLOOKUP(Customer!E2,salesrep,2,FALSE),VLOO KUP(Customer!E2*1,salesrep,2,FALSE))

worked like a charm... i didnt have my cells formated to text :)

"pshepard" wrote:

Hi Noncentz303,

If the old column in salesreps has numbers that are text; you can check this
condition by entering the following worksheet formula: =istext(A2) where A2
is one of the cells that has a number, and checking to see if it is text or
not. If the number is text, then the formula will display "TRUE".

If so, try:
=VLOOKUP(TEXT(Customer!E2,"0"),salesrep,2,FALSE)

However if =istext(Customer!E2) is TRUE for a number, then try:

=IF(ISERROR(VLOOKUP(Customer!E2*1,salesrep,2,FALSE ))=TRUE,VLOOKUP(Customer!E2,salesrep,2,FALSE),VLOO KUP(Customer!E2*1,salesrep,2,FALSE))

Please let me know if this was helpful.

Thanks,
Peggy

"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