| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vlookup
How do I call the Vlookup function in VB?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Vlookup
Application.VLookup(Arguments)
or Application.worksheetfunctions.VLookup(Arguments) "Nicole D." wrote in message ... How do I call the Vlookup function in VB? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Vlookup
Thanks. Why wouldn't this work
Sheet3.Range("AL2").Value = Application.WorksheetFunction.VLookup(C2, Pull, 7, False) "Rbp9ad" wrote: Application.VLookup(Arguments) or Application.worksheetfunctions.VLookup(Arguments) "Nicole D." wrote in message ... How do I call the Vlookup function in VB? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Vlookup
You need to explictly reference the ranges so that VB has some idea where to
look. In this case addresses won't cut it... Something like... Sheet3.Range("AL2").Value = Application.WorksheetFunction.VLookup(Sheet3.Range ("C2"), Sheet3.Range("Pull"), 7, False) -- HTH... Jim Thomlinson "Nicole D." wrote: Thanks. Why wouldn't this work Sheet3.Range("AL2").Value = Application.WorksheetFunction.VLookup(C2, Pull, 7, False) "Rbp9ad" wrote: Application.VLookup(Arguments) or Application.worksheetfunctions.VLookup(Arguments) "Nicole D." wrote in message ... How do I call the Vlookup function in VB? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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 -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Hybrid Mode
