This formula is used many times in the worksheet so I want to replace the [Filename.xls] with a cell containing the filename. That way when I reference a different workbook I only have to change the filename once instead of many times.
I have [Filename.XLS] in cell K1 and I have [Filename.XLS]SHEET1 in cell K2.
I need the =IF formula to get the filename from cell K1 or the filename and sheet name from cell K2 (either way works fine for me) and index that. I've been trying to use variations of =INDIRECT(""&$K$2&"), but can't make it work either way. Can someone please tell me how to do this?