=IF(RANDBETWEEN(INT(A1084),$BG$6)1,$BM$6,IF(RANDB ETWEEN(INT(A1084),$BG
$9)1,$BM$9,IF(RANDBETWEEN(INT(A1084),$BG$10)1,$B M
$10,IF(RANDBETWEEN(INT(A1084),$BG$11)1,$BM
$11,IF(RANDBETWEEN(INT(A1084),$BG$12)1,$BM
$12,IF(RANDBETWEEN(INT(A1084),$BG$13)1,$BM
$13,IF(RANDBETWEEN(INT(A1084),$BG$15)1,$BM
$15,IF(RANDBETWEEN(INT(A1084),$BG$16)1,$BM
$16,IF(RANDBETWEEN(INT(A1084),$BG$19)1,$BM$19,$BM $24)))))))))

I am trying to use the above formula to pick a name from a table
"column BM", the name is dependent on the values in column BG and the
variable in column A.
the formula works for the first name, but it gives #num! after that.
Can you help me please?