Forum Discussion
Help needed for understanding with structured reference
It depends on what you are trying to do, i.e.
If you're trying to get a range:
If you're trying to do an equation:
so what are you trying to do? show the desired result
here a sample file and what i wanna do
That is not a problem with structured references. If you try it with regular cell references you get a #VALUE! error. The union operator only works in certain functions.
And you are giving conflicting information: In G2 you want Sales and Goal, in N2:O2 you show Sales and % of Goal.
Support page describes union with this example:
and it does not work, I did a search for the word union:
So as it is currently described in the support page:
https://support.microsoft.com/en-us/office/using-structured-references-with-excel-tables-f5ed2452-2337-4f71-bed3-c8ae6d2b276e
it does not seem to work as "described" in the support page.
