I have a multi-tabbed workbook in which many worksheets refer to other worksheets.
I've successfully used the HLOOKUP function on one of the worksheets, but when I copy it to another worksheet and attempt to change the references in the formula, I can't get it to "save" correctly.
The working formula looks like this:
when I attempt to change the formula by referring to another worksheet, the single ' marks don't save. So when I write this:
the saved formula looks like this.
which results in a #NA cell.
I've tried saving the formula as an array (with the {}) but this doesn't help.
Any advice?
Thanks
Bookmarks