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
|