Benches Uncategorized

1

Designating table name in address function

apple Verified

Imported from the Apple Support Forums via the Wayback Machine 🔗

Ok, my turn! i just can't figure this one out. I am trying to help someone else from the forums with a spreadsheet and was trying to use the indirect function with the address function to set up a variable cell reference.

Example:
this works... (referencing a cell on the same table)

=indirect(address(1,1,1,true),true)

This does not...(referencing a cell on a different table)

=indirect(address(1,1,1,true,"other table"),true)

I cannot figure out how to select the table itself for the table reference required as the fifth argument of address. I can type it in using text, but it apparently causes an error when this is done.

I was going to wait till someone tried to figure this out with me before submitting it as a bug with apple.

Thanks ahead of time,
Jason

1 reply

Sign in or join Beachball Help to reply.

  1. 0

    Apple Support Community member

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    marking as solved just to clear my lists.