Hello,
I want a key cell (A4) to pick up the sheet name and have sucessfully done
so using the =MID(CELL("Filename",A1),FIND("]",CELL("filename",A1),1)+1,99)
formula. However, when I do this, other lookup and vlookup formulas that use
D4 as the lookup value for their calculations get the #N/A error unless I
manually type the sheet name into D4. Has anyone seen this? Is there a
workaround?
Excel 2007 @ home & 2003 @ work
Thanks in advance for any help,
Robert