Random lookup from table array when number entered

I have designed a report writing spreadsheet where when i enter a number it vlookups from sheet with data ranges. For example if i enter number 1 it will return the text in column next that number. I would like to progress it to when i enter the number 1, it will choose from 3, 4 or 5 cells to return 1 randomly and try not to repeat the same cell return if possible.

See below one of the formulas

=IF(LEN(VLOOKUP(M2,Y3Football,2,0))=0,””,VLOOKUP(M2,Y3Football,2,0))

 

Any help much appreciated.

 

Many thanks

By: Matt W

Leave a Reply

Your email address will not be published. Required fields are marked *