how to parametrise file name in VLOOKUP external link

Hopefully this link will point you in the right direction

https://www.automateexcel.com/formul...okup-indirect/

thanks, but indirect need to other file would be OPEN. I need it would be CLOSED.

you need vba on a button to refresh or on an update event, its hard with no file (s) to attach that works

IF you put this code into a module (or go view macros record macros click on a cell then stop

Co back to view macros , select your macro and edit

replace the code with the below

then draw a button on your sheet and attach your macro, it will rewrite the vlookup everytime it is pressed

Please Login or Register  to view this content.

davsth, thanks, I was hoping it would go through the formula, but I'm giving up hope. so let's program. :-)