Forum Discussion
I did it, guess so. The External Referencing.
Deleted
Hi,
I guess this formula returns current sheet name. Yes, sure, you may use it instead of <current sheet>. But again, it's much better not to complicate the formula but use helper cell. Take it in the place where end-user can't see, in addition you may hide column/row with it, add your formula into this cell and in formula with links use reference on this helper cell.
Hi Sergei,
I've tried your formula it works well.
But yeah it is a bit bulky, haha, sorry to say that, I mean, because we have too many tags here & the number is still growing so it would be a pain to use that.
IF(<current sheet>="Sheet5", [Book2.xlsx]Sheet5!A1 )
I believe if I can replace that "Sheet5" following [Book2.xlsx] with cell(), i.e. [book2]Cell() in which cell() to pick up the tag name, then it will help me get what I want in book2 under same tag, and there's no need to change the formula manually.
But in fact it is an external link, so I'm not sure if we make it like that.
So far I've tried to put cell() and [book2] together over and over and over - a big fail.
What do you think? Is that because that I use connectors in a wrong way, like misplaced & ' " so excel can't read it, if so can you please give me some ideas. Or we just cannot embed cell() in an external link?
Thanks for your time.
Deleted Bulky ! That's the word you use ! I have been wondering about this whole situation and I am please with your mans advice He will help you ! But Bulky ! THAT IS AN UNDERSTATEMENT ! Good luck in your endeavors ! Richarrut
- Haha, I'm losing faith in myself but I will try a bit more. Touch wood, touch wood.
Deleted
You may combine them with INDIRECT and that returns you back to initial problem.
- Yeah you're right. So I might, try something else I guess. Cheers
