Broadcasting is an array calculation behavior in Excel formulas.
In essence, Excel resizes arrays to be the same size.
The second range results in an array with only 1 item.
Broadcasting only pops up if the value to copy is unambiguous.
When it’s not clear what value to copy, Excel will use #N/A.
