Automatically populate a form based on a match from another worksheet.

20 pts.
Tags:
Excel Database
Excel Forms
Microsoft Excel
Ok, here goes... I have a very large talent management database that is housed in Excel. This database includes information on performance ratings, work history, education, etc. on every employee in the company. I also have a 'Talent Profile' form (also created in Excel) that I give to HR whenever they need to review an incumbents talent management information. This form includes most of the information on the talent management database, but not all. And, it's in a completely different format. Currently, I'm manually entering all of the information into the 'Talent Profile' form from the data on the talent management database. Ideally, I would like to enter the employee's ID number and have the form automatically populate based on the relevant information from the talent management database. Is this possible? If so, I'm assuming it will require a macro... Thanks in advance for the help!

Answer Wiki

Thanks. We'll let you know when a new response is added.

If I understand this problem correctly it solved pretty straightforward using the “vlookup” function. Basically this function looks up a value and returns the corresponding value in that row for a column of your choice. (the employee id number has to be the first column and 100% unique).

What you could do is enter the employee id into the ‘talent profile form’. Then select for example the cell that should contain the employee name. In this cell input the vlookup formula: <b>=vlookup(cell in the ‘talent profile form’ that contains the employee ID, database that contains the data, column in the database that contains the employee name, false </b>(if you want an exact match)<b>)</b>.

Repeat this for all cells you need to fill in the ‘profile form’ and they should be automatically generated when you enter the employee id.

No need for macro’s.
Dan

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following