Dec 22 2020 02:41 AM
Dec 23 2020 07:05 AM - edited Dec 23 2020 07:18 AM
@louisecaudal Not exactly the same. You referenced the entire column A:A in a formula that sits B2. Then Excel will not be able to spill the results as it can not display an entire column starting in row 2. You can put your formula in B1. But then Excel will spill the result to over a million cells in column B. Best to restrict the lookup range to the actual range used. Easily done if you structured tables, as demonstrated in the (revised) file attached.