Thread: Random cell return using vlookup formula
View Single Post
 
Old 05-21-2017, 01:18 PM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default
=IF(ISERROR(VLOOKUP(K69,Y6Cricket,1,0)),"",VLOOKUP (K69,Y6Cricket,1+RANDBETWEEN(1,6),0))
Reply With Quote