|
|
|
|
#1
05-21-2017, 01:18 PM
|
|||
|
|||
=IF(ISERROR(VLOOKUP(K69,Y6Cricket,1,0)),"",VLOOKUP (K69,Y6Cricket,1+RANDBETWEEN(1,6),0))
|
|
#2
05-22-2017, 03:29 AM
|
|||
|
|||
|
Thank you
Thank you for your.
This works perfectly apart from one thing, I am trying to use this formula for 3 different column look ups on the same worksheet. Once I have entered the formula in the 3 coloumns, when changing the vlookup data in one column it changes all 3. Thoughts? Matt
|
|
|
|
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 8 
Office 2016
Hybrid Mode