I did it, guess so. The External Referencing.

SergeiBaklan

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.