Return a Title based on a name
Hi,
You can't prevent every user error. If you automate the title with a
VLOOKUP, then you need to make sure they enter their name in a consistant
form. For example, John instead of J. Smith, would fail, as would Smith or
Smith, John, or J. P. Smith.
All of that said, your VLOOKUP would use a table like this
M N
Tom Jones Mr.
Ali McGraw Ms.
A. Lincoln President
....
If these are in the range M1:N30 and the user types their name into A2 with
their title appearing in B2, the formula in B2 would be:
=VLOOKUP(A2,M$1:N$30,2,)
You might consider giving the users a drop down list for their names, using
Data, Validation, List... That would eliminate the chance for a name entered
in an incorrect form. And although they might pick the wrong title, they are
not likely to pick the wrong name.
--
If this helps, please click the Yes button
Cheers,
Shane Devenshire
"AccAdmin" wrote:
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.
|