|
|
#1
05-20-2017, 01:24 PM
|
|||
|
|||
Random cell return using vlookup formula
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 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula
|
innkeeper9 | Excel | 2 | 09-13-2016 08:59 PM |
| Need a formula (possibly something like VLOOKUP) that will return multiple results. | SilverUnicorn79 | Excel | 8 | 08-16-2016 01:34 PM |
|
Formula to return next non-blank cell in a range
|
Anyroad | Excel | 4 | 09-15-2015 04:13 PM |
| Would like to return a row rather than a cell using VLookup | canajun | Excel | 7 | 12-10-2014 01:03 PM |
| Vlookup two columns return 3rd | jennamae | Excel | 11 | 01-12-2014 02:53 AM |
Windows 10 
Office 2016
Threaded Mode