Hi All,

I have two columns of numbers that need to be kept as pairs for example;

122 505
122 909
345 6576
555 676

I need to randomly choose a pair x amount of times. I am using this formula in the first output column =INDEX($I$2:$I$5,RANDBETWEEN(1,COUNTA($I:$I)),1), which is fine to choose one of the numbers of column 1, however I am struggling to match the randomly chosen first number with its corresponding second number. This is as good as I have got =INDEX($J$2:$J$5,(MATCH(L2,$I$2:$I$5,0)),). But the problem with is that is chooses the first value it finds that corresponds to the correct number in column 1. So 122 is always paired with 505 never 909. I need a way to match the randomly chosen cell location rather than the value itself.

Hope this makes sense. Thanks for any help.