vlookup question
 

i have a form that works fine if the acct number i lookup is all numeric,
12345. it will return the name in the next column. but if i add an acct
number such as ab123, it won't return anything. the list is sorted.

can't you mix the 2 types?

--


Gary

vlookup question
 

figured it out, had to add some quotes

--


Gary


"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
i have a form that works fine if the acct number i lookup is all numeric,
12345. it will return the name in the next column. but if i add an acct
number such as ab123, it won't return anything. the list is sorted.

can't you mix the 2 types?

--


Gary