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","Afeternoon","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" <edwardpestian.29wnhn_1151150102.687@excelforum-nospam.com>
wrote in message
news:edwardpestian.29wnhn_1151150102.687@excelforum-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
>