Hello,
I am trying to write a vlookup function where we are extracting numbers from different files in the same folder.
This is what I have:
=VLOOKUP(A1,"'M:\Funds\0-Valuations\Valuations 2016\Valuations Q2 2016\["&B1&" Valuation Calcs 06-30-16.xlsx]Investment History'!$D$3:$E$300",2,FALSE)
Below is simple version of that, however, I need to change V4 to cell B1, so when we change cell to V5 the file path automatically updates
=VLOOKUP(A1,'M:\Funds\0-Valuations\Valuations 2016\Valuations Q2 2016\[V4 Valuation Calcs 06-30-16.xlsx]Investment History'!$D$3:$E$183,2,FALSE)
I am trying to avoid using indirect because I need the formula to work with closed workbooks as well. Is there a way of writing this formula without using indirect function and VBA.
I am trying to write a vlookup function where we are extracting numbers from different files in the same folder.
This is what I have:
=VLOOKUP(A1,"'M:\Funds\0-Valuations\Valuations 2016\Valuations Q2 2016\["&B1&" Valuation Calcs 06-30-16.xlsx]Investment History'!$D$3:$E$300",2,FALSE)
Below is simple version of that, however, I need to change V4 to cell B1, so when we change cell to V5 the file path automatically updates
=VLOOKUP(A1,'M:\Funds\0-Valuations\Valuations 2016\Valuations Q2 2016\[V4 Valuation Calcs 06-30-16.xlsx]Investment History'!$D$3:$E$183,2,FALSE)
I am trying to avoid using indirect because I need the formula to work with closed workbooks as well. Is there a way of writing this formula without using indirect function and VBA.
