hoe to reference a random number in a list code example Example: randomly assign value from one column to cell =INDEX(data,RANDBETWEEN(1,ROWS(data)),1)