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