On 3 Sep 2006, "Ryk" wrote:

I have two cells I fill out 20-40 times a day, NAME and TITLE, and I
have a drop down box in which I have the titles. Is there a way I can
make it so that my sheet "remembers" a NAME and auto fills the title,
and, updates itself both name and title if it doesn't recognize the
name?
So next time I happen to type that name the title fills. I am sort of
proficient with excel, so fire away.

Thanx for any input....

Ryk

Ryk,

You could use a VLOOKUP to match the name you input to its
corresponding title in a table.

Let's assume you want to put the name in column A and have the title
populate in column B on one worksheet, and that you have a row with
the headers "Name" and "Title" in row 1. On a second worksheet,
create a table with the names in column A and the titles in column B.

The formula in column B of your first worksheet would look similar to
this:

=IF(A2="","",VLOOKUP(A2, Sheet2!A:B,2,FALSE))

By putting that in column B, you just have to enter the name into
column A and the cell next to it will look for the name in your table
on Sheet2 and return the title.

In the event that the person does not exist in the table on Sheet2,
this formula will return an error. You could easily clean this up by
using this formula instead:

=IF(A2="","",IF(ISNA(VLOOKUP(A2,Sheet2!A:B,2,FALSE )),"Not
Found",VLOOKUP(A2,Sheet2!A:B,2,FALSE)))

Now you would get the text "Not Found" if the person isn't in the
table, rather than the standard "#N/A" error.

MP-