Show Me The Function !!

[Dtree11]

4000 points to the person who answers this riddle:

I have a problem in excel, I have four sheets of data that shares certain pieces of information. In the largest data sheet, Column A has names and Column B has their corresponding job titles. Well, the other worksheets only have Column A (Names). Manually writing in the corresponding job titles is out of the question, because there is an incredible amount of names. I need to write a function that will automatically fill in the job title based on the name. So far I was able to make separate columns that listed the names based on the job title heading, all on the same sheet. Now I need to have one column that gives the job titles and is aligned with the corresponding names. I do not care if the Job titles were given a numerical name, to make things easier.

[pam123]

I think Excel has an insert column function which should give you the option of copying the column with the job titles and putting it into the spreadsheet(s) of your choice.
Hang on while I go check it out.

edit : http://www.uwec.edu/help/Excel03/ws-rowcol.htm#addrem

[mairving]

You also need to avoid using names since they are problematic. That is they change, have spaces in them and can be duplicated. It would be best to assign a name to an id which is numeric. So instead of linking by Tom Aaron, you would link by the id which would be 1.

Also remember that Excel is a spreadsheet albeit a powerful one. What you are trying to do would best be done in a database like Access.