VLookup does not work with "("
This works fine on my PC. Seems OK to me.
The only way I can generate that error is if
(555)555-5555
is not in any of the cells b3 to b15.
Double check it is really there. Copy paste it from your program text.
Check that what you have got is not some kind of number being reformatted.
--
Allllen
"Drgn_Btl" wrote:
I am trying to use a macro to search for data containing "(". Sample code
below:
***************
Sub test()
Return_Value = WorksheetFunction.VLookup("(555)555-5555",
Worksheets(1).Range("B3:C15"), 2, True)
End Sub
For whatever reason I get error 1004, VLookup cannot read the lookup_value.
Thanks,
Drgn_Btl
|