Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using VLOOKUP in VBA
I am using VBA code to print reports from an SQL database using Excel as the
front end. I am trying to use VLOOKUP to find data from a list in one spreadsheet and include it in an Excel spreadsheet. Here is the code: If Application.WorksheetFunction.IsNA(Application.Wor ksheetFunction.VLookup(cnn, Sheets("Custname").Range("CN"), 4, False)) = False Then cname = Application.WorksheetFunction.VLookup(cnn, Sheets "Custname").Range("CN"), 4, False) Else cname = "--" End If If the data cannot be found, I want to enter dashes in the variable 'cname'l, but if data is found, I want to enter that data in the variable. The code runs fine as long as the lookup fines data, but if it doesn't the program halts. What am I doing wrong, and if this doesn't work, what will? Thanks. -- Greg |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using VLOOKUP in VBA
Greogrory
Adjust this code its something I have used in the past. Result = Application.VLookup(Find_CMR, GMB_Table, C + 1, 0) If IsError(Result) Then .Cells(5 + i + step, 12 + C) = "--" End If "Gregory Howard" wrote in message ... I am using VBA code to print reports from an SQL database using Excel as the front end. I am trying to use VLOOKUP to find data from a list in one spreadsheet and include it in an Excel spreadsheet. Here is the code: If Application.WorksheetFunction.IsNA(Application.Wor ksheetFunction.VLookup(cnn, Sheets("Custname").Range("CN"), 4, False)) = False Then cname = Application.WorksheetFunction.VLookup(cnn, Sheets "Custname").Range("CN"), 4, False) Else cname = "--" End If If the data cannot be found, I want to enter dashes in the variable 'cname'l, but if data is found, I want to enter that data in the variable. The code runs fine as long as the lookup fines data, but if it doesn't the program halts. What am I doing wrong, and if this doesn't work, what will? Thanks. -- Greg |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If (Vlookup 0) working, but what if Vlookup cell does not exist | Excel Worksheet Functions | |||
VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |