replace numbers with names

xor · #1 12-12-2016, 02:03 AM

Can you accept that numbers are entered in for example rows 2:6 and then the corresponding names appear in rows 24:28?

shivy · #2 04-01-2017, 06:52 AM

Quote:

Originally Posted by xor

Can you accept that numbers are entered in for example rows 2:6 and then the corresponding names appear in rows 24:28?

Sure, I'm looking for the solution, so I can try any suggestion.
I've tried =INDEX($Q$1:$Q$14,MRAND()+1) functions, but notice it repeats ppl on the same task on the following day...so this is no good.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Find and replace BETWEEN numbers	WordUser2015	Word	4	12-19-2014 02:09 PM
Replace 0000s with a series of numbers	tingker	Word VBA	2	12-17-2014 06:06 AM
Find and replace inside strings containing various names	audioman	Word VBA	4	03-25-2014 11:19 AM
find and replace consecutive numbers	kpl_39	Word	1	06-07-2013 05:04 AM
Find & Replace formula for numbers?	Griff	Word	4	04-18-2011 02:47 AM