V look up help needed

[manoj18071965]

I have an excel spreadsheet having information in two sheets i.e. sheet 1 and sheet 2
Sheet 1 has 3 columns.
Column A (Description) consists of repetitive values
Column B (Job Title) Blank cells {Information needs to be populated from Sheet 2}
Column C (University) Blank cells {Information needs to be populated from Sheet 2}

Sheet 2 has 3 columns
Column A (Description) consists of only unique values which are repetitively appearing in Sheet 1 Column A
Column B consist of Job Titles
Column C consists of University names
Matching both Sheet 1 & 2 column A, I am looking for formula to auto populate values in column B & C of sheet 1. Example is below:

Description	Job Title	University
Assoc Prof. Seton Hall University School of Law.	Assoc Prof.	Seton Hall University School of Law.
Assoc Prof. St. John's.	Assoc Prof.	St. John's.
Assoc Prof. St. Mary's University of San Antonio School of Law.	Assoc Prof.	St. Mary's University of San Antonio School of Law.
Assoc Prof. Stanford. BA, 2000, Cal., Berkeley	Assoc Prof.	Stanford. BA, 2000, Cal., Berkeley
Assoc Prof. State Univer- sity of New York at Buffalo School of Law.	Assoc Prof.	State Univer- sity of New York at Buffalo School of Law.
Assoc Prof. The Judge Ad- vocate General's School, U.S. Army.	Assoc Prof.	The Judge Ad- vocate General's School, U.S. Army.
Assoc Prof. Univ. of No. Car..	Assoc Prof.	Univ. of No. Car..

<tbody>
</tbody>

 

[tico_ocit]

=VLOOKUP($A$2,Sheet2!$A$2:$C$10,2,FALSE)

- Job Titles

=VLOOKUP($A$2,Sheet2!$A$2:$C$10,3,FALSE)

- University

Sheet1

Description	Job Title	University
Assoc Minho University	Professor	Minho University

<tbody>
</tbody>

Sheet2

Description	Job Title	University
Assoc Minho University	Professor	Minho University

<tbody>
</tbody>

For what I understood, description is unique, so I went for search on Sheet2 each "Description" and then get the correspondent Jobtitle and University.

Is that want you were looking for?

 

[manoj18071965]

It doesnot solved the purpose. by using this formula values are displaying as stated below:

Description	Job Title	University
Assoc Prof. Seton Hall University School of Law.	Assoc Prof.	Seton Hall University School of Law.
Assoc Prof. St. John's.	Assoc Prof.	Seton Hall University School of Law.
Assoc Prof. St. Mary's University of San Antonio School of Law.	Assoc Prof.	Seton Hall University School of Law.
Assoc Prof. Stanford. BA, 2000, Cal., Berkeley	Assoc Prof.	Seton Hall University School of Law.
Assoc Prof. State Univer- sity of New York at Buffalo School of Law.	Assoc Prof.	Seton Hall University School of Law.
Assoc Prof. The Judge Ad- vocate General's School, U.S. Army.	Assoc Prof.	Seton Hall University School of Law.
Assoc Prof. Univ. of No. Car..	Assoc Prof.	Seton Hall University School of Law.
Assoc Prof. University of Miami School of Law.	Assoc Prof.	Seton Hall University School of Law.
Assoc Prof., George Mason.	Assoc Prof.	Seton Hall University School of Law.
Assoc Prof., George Mason. AB, 2000, Dartmouth Coll.	Assoc Prof.	Seton Hall University School of Law.
Assoc Prof., Legal Rea- soning, Res. & Writing. Boston Coll..	Assoc Prof.	Seton Hall University School of Law.

<colgroup><col><col><col span="2"></colgroup><tbody>
</tbody>

 

[manoj18071965]

By Editing formulas as below things worked. Thank you for your help!!!

Job Title
=VLOOKUP(A2,Sheet2!$A$2:$C$19,2,FALSE)

University
=VLOOKUP(A2,Sheet2!$A$2:$C$21,3,FALSE)

 

[tico_ocit]

By Editing formulas as below things worked. Thank you for your help!!!

Job Title
=VLOOKUP(A2,Sheet2!$A$2:$C$19,2,FALSE)

University
=VLOOKUP(A2,Sheet2!$A$2:$C$21,3,FALSE)

Nice! I'm glad I could help!