Hello,
I'm using this function to pull the last value in a column, but I need to replace with Indirect as my macro constantly delete and replace the tabs.
this gave me error, I think it has something to do with the "" as part of the indirect, can someone please help?
=LOOKUP(2,1/(INDIRECT("'"K22&"'!Q:Q<>"")),Indirect("'"&K22&"'!Q:Q"))
Bookmarks