Random cell return using vlookup formula

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Random cell return using vlookup formula

05-21-2017, 01:18 PM

ArviLaanemets ArviLaanemets is offline

Windows 8

Office 2016

Expert

Join Date: May 2017

Posts: 949

=IF(ISERROR(VLOOKUP(K69,Y6Cricket,1,0)),"",VLOOKUP (K69,Y6Cricket,1+RANDBETWEEN(1,6),0))

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:52 PM.