How to do a cross sheet reference

SherryFox

I cannot believe I do not remember how to do this!!!!! I need to create a Cross sheet reference. Now I will be referencing a cell that will be TEXT, not a number. This is the sheet I will access for my formula. I have circled in Red the sheet name and the cell I want to reference. It will only be this single cell, not a column. Thanks in advance!

Darren Mullen

@SherryFox yes, that works as long as you didn't need to use it in a formula

Darren Mullen

@SherryFox Create it the same way as you would for a column range, but just select the single cell.

SherryFox

@Darren Mullen ,

For some reason, I was having issues getting that done. So opted for Plan B, which is Right click on the cell I want the formula in, and then select this. So much easier!!!!!

Darren Mullen

@SherryFox yes, that works as long as you didn't need to use it in a formula