Using A Cell To Reference The Name Of Sheet In A Formula In Excel

Question

I have the same problem as this question.

The solution provided also works in excel, but for an empty cell in the referenced sheet it prints 0 rather than leaving it empty. Is there a better way to do this where an empty cell would stay empty after referenced?

Where would I add that? Let's say I have INDIRECT("'"&A1&"'!A1") — SaTa, Dec 05 '18 at 18:53
Thanks, it worked! I used ```=IF(ISBLANK(INDIRECT("'"&A3&"'!A2")),"", INDIRECT("'"&A3&"'!A2"))``` — SaTa, Dec 05 '18 at 22:30

score 1 · Accepted Answer · answered Dec 05 '18 at 22:08

1

You can try adding &"" to the end of your formula; for example: ='Sales Report - WB 10.06'!B3&""

answered Dec 05 '18 at 22:08

Justyna MK

3,523
3
11
25

Thanks, I tried ```=INDIRECT("'"&A3&"'!A2")&""``` and it worked. – SaTa Dec 05 '18 at 22:33

Using A Cell To Reference The Name Of Sheet In A Formula In Excel

1 Answers1