View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
sugargenius sugargenius is offline
external usenet poster
 
Posts: 26
Default match function with text and numbers


Gary''s Student wrote:
Always use a string

Dim s as String
s = "AA"
call LookupNLHand(s)
s="99"
call LookupNLHand(s)
--
Gary's Student


Using your examples, "AA" works fine but "99" throws error 2042 on the
vlookup