79735654

Date: 2025-08-14 15:59:07
Score: 2.5
Natty:
Report link

Just to add something to the discussion about the functionality of INDIRECT() in this case:

Using it like shown below leads to the error described.

A1 contains SEQUENCE(5), B1 contains ="A"&A1#

But using the reference in quotation marks does make it work like this:

Again, A1 contains SEQUENCE(5), B1 contains "A"&A1#

Reasons:
  • Probably link only (1):
  • Low length (0.5):
  • No code block (0.5):
  • Low reputation (0.5):
Posted by: LuPi1801