Book1 



 A  B  C  D  E  F  G 

1   number1  number2  number3  number4  number5  number6 

2  staff1  18  44  9  48  2  11 

3  staff2  31  16  20  8  10  11 

4  staff3  21  32  1  39  14  3 

5  staff4  35  12  43  33  37  3 

6  staff5  43  36  7  8  4  18 

7  staff6  10  28  29  25  26  33 

8  staff7  49  20  41  42  48  33 

9        

10        

11        

12  draw1  18  44     

13  draw2  31  16  20  8  10  

14  draw3       

15  draw4       

16  draw5       



i managed to work out the array formula, it is
set you sheet out as in my example then in your first row of numbers my example B2 goto conditional formatting and select fomula is and enter the above formula. choose formats as required
then click ok, right click on the first number and click copy, highlight the rest of your numbers to be checked and right click, Paste Special >> FORMATS this will copy the formats to the rest of your cells,
now enter numbers in the draws boxes and number drawn will highlight
the B2 in my formula is the first cell of my numbers to be checked
the =$B$12:$G$16 is the range of the draw1 to draw5 cells adjust as required but remember to use absolute refrences ($) in this part
HTH