Hi
I have been designing a school report spreadsheet. I am looking to randomly select from a table array using vlookup. Basically at the moment when i enter a number in one worksheet it looks up from another worksheet, finds the name definition and returns the cell next to the number. I would like it to randomly select and return text from 5 or 6 cells next to the number so children don't get the same comment if they get the same effort grade. I hope the makes sense.
Formula so far
=IF(LEN(VLOOKUP(K69,Y6Cricket,2,0))=0,"",VLOOKUP(K 69,Y6Cricket,2,0))
Thanks
Matt