Hello Folks,
Visited many times, first post. This is my formula...=INDEX(INDIRECT("'"&E7&"'!D2:D2"),0) works great. However, SpreadSheetConverter does not allow the indirect function. I need to publish to a website.
How can I complicate this formula without using indirect. E7 will be a...