Designating table name in address function
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.
- 0