Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLookup a named range
On Aug 23, 12:55*pm, "Charlotte E." wrote:
I have a named range on a worksheet, called 'TableRange'. Making a vlookup in a worksheet formula will be like this =VLOOKUP(F17,TableRange,2,1) How to do this in VBA??? D = Application.Vlookup(cVal,"TableRange",2,1) ...doesn't work :-( TIA CE You don't need the ,1 parameter as it is the default. See the help index = Application.Vlookup(cVal,range("TableRange"),2) or try = Application.Vlookup(cVal,[TableRange],2) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLookup a named range
I have a named range on a worksheet, called 'TableRange'.
Making a vlookup in a worksheet formula will be like this =VLOOKUP(F17,TableRange,2,1) How to do this in VBA??? D = Application.Vlookup(cVal,"TableRange",2,1) ....doesn't work :-( TIA CE |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLookup a named range
Charlotte E. expressed precisely :
I have a named range on a worksheet, called 'TableRange'. Making a vlookup in a worksheet formula will be like this =VLOOKUP(F17,TableRange,2,1) How to do this in VBA??? D = Application.Vlookup(cVal,"TableRange",2,1) ...doesn't work :-( TIA CE D = Application.WorksheetFunction.VLookup(cVal, "TableRange",2) -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLookup a named range
None of them work??? The name refers to a range in another workbook: TableRange ='D:\\Data\Spreadsheets\Tables\[Rates.XLS]Rates'!$A:$CV I have no problem doing it in a worksheet cell as a normal formula, but how to do it in VBA??? CE Den 23.08.2011 19:53, Don Guillett skrev: On Aug 23, 12:55 pm, "Charlotte wrote: I have a named range on a worksheet, called 'TableRange'. Making a vlookup in a worksheet formula will be like this =VLOOKUP(F17,TableRange,2,1) How to do this in VBA??? D = Application.Vlookup(cVal,"TableRange",2,1) ...doesn't work :-( TIA CE You don't need the ,1 parameter as it is the default. See the help index = Application.Vlookup(cVal,range("TableRange"),2) or try = Application.Vlookup(cVal,[TableRange],2) |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLookup a named range
Charlotte E. formulated on Wednesday :
None of them work??? The name refers to a range in another workbook: TableRange ='D:\\Data\Spreadsheets\Tables\[Rates.XLS]Rates'!$A:$CV I have no problem doing it in a worksheet cell as a normal formula, but how to do it in VBA??? CE Den 23.08.2011 19:53, Don Guillett skrev: On Aug 23, 12:55 pm, "Charlotte wrote: I have a named range on a worksheet, called 'TableRange'. Making a vlookup in a worksheet formula will be like this =VLOOKUP(F17,TableRange,2,1) How to do this in VBA??? D = Application.Vlookup(cVal,"TableRange",2,1) ...doesn't work :-( TIA CE You don't need the ,1 parameter as it is the default. See the help index = Application.Vlookup(cVal,range("TableRange"),2) or try = Application.Vlookup(cVal,[TableRange],2) Open the workbook and ref the range as follows: Set TableRange = _ Workbooks("Rates.XLS").Sheets("Rates").Range("$A:$ CV") Otherwise, you'd have to use ADO to load the data into a recordset without opening the file in Excel. -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLookup a named range
Hey,
Simply use range("range").value = "=VLOOKUP(F17,TableRange,2,1)" On Aug 23, 10:55*pm, "Charlotte E." wrote: I have a named range on a worksheet, called 'TableRange'. Making a vlookup in a worksheet formula will be like this =VLOOKUP(F17,TableRange,2,1) How to do this in VBA??? D = Application.Vlookup(cVal,"TableRange",2,1) ...doesn't work :-( TIA CE |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using a dynamic named range in a VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup in a named range | Excel Worksheet Functions | |||
Vlookup in large named range | Excel Worksheet Functions | |||
Using named range in vlookup | Excel Programming | |||
Vlookup on named range | Excel Programming |