delete Row creates Ref - use Indirect formula but can\'t get it to work Hi I hav

Question

delete Row creates Ref - use Indirect formula but can't get it to work

Hi

I have a sheet called People where all members of club are listed. I want Team Leaders to be able to delete or add people to this tab and then updated names will pull through to monthly sheets. Trouble is that when i delete rows i get Ref in monthly tabs.

So in cell A17 of first month tab I have =INDIRECT("'"&PEOPLE!A4&"'!"&CELL("address",PEOPLE!A4)) which I had hoped would bring back the value in People!A4 but it is comong back Ref#. I want to be able to drag the formula in cell A17 down so it chnages to return value in cells below A4. Where am I going wrong?

Thanks !!

Explanation / Answer

Hi,

Try this.

=INDIRECT("People!A" & ROW(A4)).

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.