Hi Guys,

It's me again ...

I have a random name generator using this formula: 
=IF(B3="Go",INDEX(Namelist,RANDBETWEEN(1,69)),"")
Is there any way of making the criteria determined by a month and year entered in B2. (instead of hard coding the 1,69 in the formula).

So, if I enter 'March 2017' in B2 it looks column D of tab 'List of Names' and only randomly generates a return from Namelist if the date in column D is March 2017.

Ta!

Terry