Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
error 2042 with vlookup
I have a named range ("LC_Chars"), and am trying to use the following code:
sz = Application.VLookup(x, LC_Chars, 2, False) It is comparing a single character (x; in this case x="7", though the error is generated no matter what the value of x.). The named range contains two columns. The search column has been formatted as text and does contain a "7". The fix has to be simple, but I'm not seeing it. Bert |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error 2042 | Excel Programming | |||
VBA code to erase an array element returning Error 2042 ??? | Excel Programming | |||
vlookup error 2042 | Excel Programming | |||
Excel xlodbc error 2042 with SQLRetrieve | Excel Programming | |||
Error 2042 | Excel Programming |