hi all - been trying to use a vlookup formula to get a result. lots of variables in this.
- look up value is dynamic
- the path/file to be looked up is dynamic, so i was using a formula in this cell (K9) to build the path/file name
i tried to use this formula but all i get is #REF!: =VLOOKUP(C5,INDIRECT("'["&K9&"]Data'!$B$55:$C$80"),2,0)
the file is on a network path, hope that doesn't matter. When i directly code it in like this it works, even when the source book is closed.
VLOOKUP(C5,'\\mdzausutwfnp001\shardata\IL6S\07 Health, Safety & Environment\Pillar Work Processes\BOS\2021 BOS Tracking\2021 BOS Trackers\[2021 BOS Tracker - Hart Fill-Pack - DO NOT OVERWRITE.xlsm]Data'!$B$55:$C$80,2,0)
where am i going wrong?
TIA
- look up value is dynamic
- the path/file to be looked up is dynamic, so i was using a formula in this cell (K9) to build the path/file name
i tried to use this formula but all i get is #REF!: =VLOOKUP(C5,INDIRECT("'["&K9&"]Data'!$B$55:$C$80"),2,0)
the file is on a network path, hope that doesn't matter. When i directly code it in like this it works, even when the source book is closed.
VLOOKUP(C5,'\\mdzausutwfnp001\shardata\IL6S\07 Health, Safety & Environment\Pillar Work Processes\BOS\2021 BOS Tracking\2021 BOS Trackers\[2021 BOS Tracker - Hart Fill-Pack - DO NOT OVERWRITE.xlsm]Data'!$B$55:$C$80,2,0)
where am i going wrong?
TIA