Generate Random List based on Criteria from Separate Column in Excel

I have two columns - one that has paragraph numbers listed and another is its Frequency - how often it's surveyed (i.e. Annually, Monthly or N/A).

I want to search the Frequency column to randomly select any row that is not N/A and return the number listed in the previous column for that random selection.

I know how to randomly select and return the paragraph number just based on a search of that column: =INDEX(Master[PWS-4],RANDBETWEEN(1,ROWS(Master[PWS-4])),1)

But this won't search based upon the criteria in the Frequency column, of course. I then tried adding an IF function:

=IF(Master[Frequency]<>"N/A",INDEX(Master[PWS-4],RANDBETWEEN(1,ROWS(Master[PWS-4])),1),"")

I feel like adding the IF function first isn't the right step (and it certainly isn't getting me the result I want) but I'm unsure how to successfully return the result from one column based upon the random selection from another based on criteria. Any help would be greatly appreciated!