INDIRECT Syntax
 

Hello, I have an issue that should be easy to fix but I can't seem to
get the right syntax for the INDIRECT function.
I am trying to reference a cell in another worksheet. When I copy the
formula across, I would like it to still reference the sheet but also
reference the next cell over. The INDIRECT syntax I am using is..

....INDIRECT("'"&$B4&"'!E3")... Cell B4 contains the name of the
worksheet I am referencing. When I copy the formula over to the next
column it still references E3. I would like it to reference cell F3 of
the worksheet name in cell B4.

Any help would be greatly appreciated! Thank you in advance.

INDIRECT Syntax
 

This is one way of doing that:

=INDIRECT("'"&$B4&"'!"&CHAR(64+COLUMN(E$1))&ROW($A 3))

This will also enable you to copy down if you wish to get the cells
from E3, E4, E5 etc.

Hope this helps.

Pete

On Nov 19, 10:31*pm, cardan wrote:
Hello, I have an issue that should be easy to fix but I can't seem to
get the right syntax for the INDIRECT function.
I am trying to reference a cell in another worksheet. *When I copy the
formula across, I would like it to still reference the sheet but also
reference the next cell over. * The INDIRECT syntax I am using is..

...INDIRECT("'"&$B4&"'!E3")... *Cell B4 contains the name of the
worksheet I am referencing. When I copy the formula over to the next
column it still references E3. I would like it to reference cell F3 of
the worksheet name in cell B4.

Any help would be greatly appreciated! *Thank you in advance.