Return a Title based on a name
I considered using a drop down but changed my mind, I am trying for a more
automated worksheet. As well the user may inadvertently select the incorrect
title.
"Reitanos" wrote:
Are you suggesting that if someone types a name into one cell, you
would like their title to appear in another cell?
You could do this with a lookup (eg VLOOKUP). You might also want to
consider using a drop-down and allowing them to select their name to
avoid typos that could mess up the result of the lookup.
On Dec 30, 6:06 pm, AccAdmin
wrote:
I have a proposal sheet used by multiple users, and I would like the cell I
have dedicated to the title of the individual proposing the work to be filled
out automatically once they have placed there name in the cell dedicated for
a signature. Any and all help would be greatly appreciated.
|