=vLOOKUP($A$4,INDIRECT(sheet1!$A$1),2,FALSE)
(sheet1!$A$1) contains a dynamic formular that returns a range name. This range had been found on sheet4 but I need to move it to a seperate file. How do I tell the vLookup formular to look in another file for this dynamic range?
(sheet1!$A$1) contains a dynamic formular that returns a range name. This range had been found on sheet4 but I need to move it to a seperate file. How do I tell the vLookup formular to look in another file for this dynamic range?