CODEWITHSUNDEEP
excelexcel-indirect
Eric
Eric

Reputation: 4061

Draggable Indirect Excel

I have this formula:

=IF($C7="Y",INDIRECT("'"&$A7&"'!D$12"),0)

But I want to make the D in D$12 draggable. I've tried adding & but it's not working.

The A7 portion is draggable, which I want.

Help greatly appreciated.

Upvotes: 1

Views: 147

Answers (1)

Dmitry Pavliv
Dmitry Pavliv

Reputation: 35853

Try to use following formula

=IF($C7="Y",INDIRECT("'" & $A7 & "'!" & CELL("address",D$12)),0)

Upvotes: 3

Related Questions