| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLookup does not work with "("
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| will vlookup work for me? | Excel Worksheet Functions | |||
| vlookup does not work between 71% to 79% refernceing roundup numb | Excel Worksheet Functions | |||
| Need Vlookup to work with formula in reference cell | Excel Discussion (Misc queries) | |||
| IF / VLOOKUP formula won't work until saved | Excel Worksheet Functions | |||
| VLOOKUP won't work | Excel Worksheet Functions | |||
Threaded Mode
