Regarding Index/Match function

DanielGD

I have a work sheet that uses Index/Match formula.

The reference sheet is separate from the worksheet.

Question - If I share both sheets with a coworker and they save both on their computer. Will the sheet be able to find the reference sheet without any intervention (i.e. redoing the formula)

Thanks

DanielGD

Thank you for the info and links!!

Genevieve P.

Hi @DanielGD

The formula will show up for anyone shared to the Worksheet with any permissions (including Viewer); you don't even need to share that person to the Reference sheet for them to be able to view the formula data.

See: Tips for working with references. This article also contains a chart that identifies the Permissions needed for cross sheet formulas.

Cheers,

Genevieve

DanielGD

Thank you for the info and links!!