Create a lookup table like so
A1 = jdoe1 B1 = John Doe 1
etc., and then use
="Good"&
LOOKUP(MOD(NOW(),1),{0,0.5,0.75},{"Morning","Afete rnoon","Evening"})&
VLOOKUP(GetName(2),A1:B10.2,False)&
"Today is"&" "&TEXT(TODAY(),"mmmm dd, yyyy")
--
HTH
Bob Phillips
(replace xxxx in the email address with gmail if mailing direct)
"edwardpestian"
wrote in message
news:edwardpestian.29wnhn_1151150102.687@excelforu m-nospam.com...
How do I convert their username to their real name. Let's say that I
put each user's real name in a cell range: A1:A3. If the username is
jdoe1 then return A1, if the username is jdoe2, then return A2, etc.
A1 = John Doe 1
A2 = John Doe 2
A3 = John Doe 3
Thanks.
ep
--
edwardpestian
------------------------------------------------------------------------
edwardpestian's Profile:
http://www.excelforum.com/member.php...o&userid=33809
View this thread: http://www.excelforum.com/showthread...hreadid=555196