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