Forum Discussion

AlistairD's avatar
AlistairD
Copper Contributor
Apr 10, 2021
Solved

Using named range without auto spill

Hi,

In the attached spreadsheet I have defined 'Data' as a range name for three numbers in a column A. I want to put the content of cell A2 into B2 using =Data (rather than =A2). However, the formula returns all the values of the range name Data instead of the value of A2 alone. How can I turn off the auto spill and just get the value that corresponds to row 2?

Thanks Alistair 

PS I'm using Microsoft 365 Excel 16.47.1 on Mac OS 11.2.3

Resources