Titus,

Post an example of the data in column BG and BM, and what is in cell A1084, and describe (in word)
what you actually want the formula to do.

HTH,
Bernie
MS Excel MVP


"Titus" wrote in message
oups.com...
=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?