| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic vlookup from a close workbook
I am trying (very unsuccessfully) to create a vba function that will be like
vlookup but will look in other sheets have 3 argument. My problem is how to pass the reference to the other sheet to the function I am aware I can do this without a function: =VLOOKUP(A1,'C:\Desktop\[test3.xls]Sheet2'!$A$1:$C$18,3,FALSE) But then if I try to do: =VLOOKUP(A1,"'C:\Desktop\"&A2,3,FALSE) A2= [test3.xls]Sheet2'!$A$1:$C$18 It does not work Any idea? Dan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic chart pasted to a new workbook in report can't be dynamic | Charts and Charting in Excel | |||
| Hide all Sheets in Workbook then Close Workbook | Excel Programming | |||
| Open New Workbook / Save and Close Current Workbook | Excel Programming | |||
| Closing a workbook from a macro doesn't close the workbook | Excel Programming | |||
| Help on Workbook close and workbook save events | Excel Programming | |||
Threaded Mode
