Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use "VLookup" function
i want to know that how to use "VLookup" function in VBA?
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use "VLookup" function
There is plenty of informationin the Excel help
-----Original Message----- i want to know that how to use "VLookup" function in VBA? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use "VLookup" function
dim target as Range
Dim lookRange as Range Dim res as Variant Set target = Range("A1") Set lookRange = worksheets("Sheet2").Range("A1:F300") res = Application.Vlookup(Target,lookRange,2,False) if iserror(res) then ' not found else msgbox "Result is " & res End if -- Regards, Tom Ogilvy "Grey" wrote in message ... i want to know that how to use "VLookup" function in VBA? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text "comparison" operator for "contains" used in an "IF" Function | Excel Worksheet Functions | |||
vlookup function returning "na" even though the vlaues are present | Excel Worksheet Functions | |||
Excel crashes when typing "false" in VLookup function | Excel Worksheet Functions | |||
correct syntax for nesting "if", "and", and "vlookup"....if possib | Excel Worksheet Functions | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) |