Hi. I'm using the LOOKUP function to pull data onto a worksheet from a different workbook. I want the returned value of the LOOKUP statement to replace the actual LOOKUP statement. I want to do this because I am afraid that the original source worksheet will be moved/renamed/altered/whatever and I don't want the results of the LOOKUP to be affected if any of those things happen.
I know that I can do a COPY and PASTE SPECIAL-VALUE of the value that is returned in the LOOKUP function which will replace the LOOKUP function with whatever was returned. I want to accomplish the same thing but without having to do a COPY-PASTE SPECIAL:VALUE for each LOOKUP function because I would have to do this hundreds of time.
Does anyone know a better way to do this?
Bookmarks