Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-11-2016, 09:17 AM
shivy shivy is offline replace numbers with names Windows XP replace numbers with names Office 2007
Novice
replace numbers with names
 
Join Date: Jun 2010
Posts: 8
shivy is on a distinguished road
Default replace numbers with names


Hello, I have a table with days and tasks to do. Then another one with names and respective numbers. When I type a person's number in the task table, I would like excel to replace the number with the name of the person.
Is this possible to do ?
thank you for your help.
Attached Images
File Type: png numbers to ppl.png (7.5 KB, 23 views)
Reply With Quote
  #2  
Old 12-12-2016, 02:03 AM
xor xor is offline replace numbers with names Windows 10 replace numbers with names Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

Can you accept that numbers are entered in for example rows 2:6 and then the corresponding names appear in rows 24:28?
Reply With Quote
  #3  
Old 12-12-2016, 09:31 AM
gebobs gebobs is offline replace numbers with names Windows 7 64bit replace numbers with names Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Or forget about the numbers entirely and just use a validation list for each cell in the table.
Reply With Quote
  #4  
Old 04-01-2017, 06:52 AM
shivy shivy is offline replace numbers with names Windows XP replace numbers with names Office 2007
Novice
replace numbers with names
 
Join Date: Jun 2010
Posts: 8
shivy is on a distinguished road
Default

Quote:
Originally Posted by xor View Post
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.
Reply With Quote
  #5  
Old 04-01-2017, 06:54 AM
shivy shivy is offline replace numbers with names Windows XP replace numbers with names Office 2007
Novice
replace numbers with names
 
Join Date: Jun 2010
Posts: 8
shivy is on a distinguished road
Default

Quote:
Originally Posted by gebobs View Post
Or forget about the numbers entirely and just use a validation list for each cell in the table.
Does validation list pick random ppl to random tasks & doesn't repeat them ?
Reply With Quote
  #6  
Old 04-01-2017, 09:45 AM
xor xor is offline replace numbers with names Windows 10 replace numbers with names Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

If you in the attached file anywhere in A1:Z100 enter one of the numbers 1 to 8 Excel will automatically change that number to the corresponding name according to your list.
Attached Files
File Type: xlsm ReplaceWhenEntering.xlsm (19.4 KB, 11 views)
Reply With Quote
  #7  
Old 04-01-2017, 10:15 AM
jeffreybrown jeffreybrown is offline replace numbers with names Windows Vista replace numbers with names Office 2007
Expert
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

Or with your layout in post #1 and a minor switch to the names...
Attached Files
File Type: xlsm Vlookup.xlsm (13.8 KB, 8 views)
Reply With Quote
Reply

Tags
names, numbers, replace

Thread Tools
Display Modes


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
replace numbers with names Find & Replace formula for numbers? Griff Word 4 04-18-2011 02:47 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:55 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft