Apr 22 2023 03:55 PM - edited Apr 22 2023 03:56 PM
I have a simple indirect formula that returns a named range, the range changes and on certain ranges there are values missing from the output. What could be causing this?
Apr 22 2023 09:45 PM - edited Apr 23 2023 08:24 AM
@rn518 Well, that screenshot doesn't say much. What's in G2 on the other sheet, for instance? Most likely, it contains a value that is not a valid named range. For example, if it contains "xxx yyy" the named range would be "xxx_yyy" as spaces are not allowed in names for ranges.
On https://exceljet.net/articles/named-ranges you can read about the rules for named ranges.
When creating named ranges, follow these rules:
Apr 23 2023 06:20 AM
@Riny_van_Eekelen G2 contains a formula that produces a named range based on other variables in the sheet, and I have verified that the output is a valid name. However, I did remove the IFERROR from my formula to check this and that seemed to fix it, not sure what the issue was lol.