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:
[TABLE="width: 702"]
<tbody>[TR]
[TD]Description
[/TD]
[TD]Job Title
[/TD]
[TD]University
[/TD]
[/TR]
[TR]
[TD]Assoc Prof. Seton Hall University School of Law.
[/TD]
[TD]Assoc Prof.
[/TD]
[TD]Seton Hall University School of Law.
[/TD]
[/TR]
[TR]
[TD]Assoc Prof. St. John's.
[/TD]
[TD]Assoc Prof.
[/TD]
[TD]St. John's.
[/TD]
[/TR]
[TR]
[TD]Assoc Prof. St. Mary's University of San Antonio School of Law.
[/TD]
[TD]Assoc Prof.
[/TD]
[TD]St. Mary's University of San Antonio School of Law.
[/TD]
[/TR]
[TR]
[TD]Assoc Prof. Stanford. BA, 2000, Cal., Berkeley
[/TD]
[TD]Assoc Prof.
[/TD]
[TD]Stanford. BA, 2000, Cal., Berkeley
[/TD]
[/TR]
[TR]
[TD]Assoc Prof. State Univer- sity of New York at Buffalo School of Law.
[/TD]
[TD]Assoc Prof.
[/TD]
[TD]State Univer- sity of New York at Buffalo School of Law.
[/TD]
[/TR]
[TR]
[TD]Assoc Prof. The Judge Ad- vocate General's School, U.S. Army.
[/TD]
[TD]Assoc Prof.
[/TD]
[TD]The Judge Ad- vocate General's School, U.S. Army.
[/TD]
[/TR]
[TR]
[TD]Assoc Prof. Univ. of No. Car..
[/TD]
[TD]Assoc Prof.
[/TD]
[TD]Univ. of No. Car..
[/TD]
[/TR]
</tbody>[/TABLE]

 

[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[TABLE="width: 346"]
<tbody>[TR]
[TD]Description[/TD]
[TD]Job Title[/TD]
[TD]University[/TD]
[/TR]
[TR]
[TD]Assoc Minho University[/TD]
[TD]Professor[/TD]
[TD]Minho University[/TD]
[/TR]
</tbody>[/TABLE]

Sheet2
[TABLE="width: 334"]
<tbody>[TR]
[TD]Description[/TD]
[TD]Job Title[/TD]
[TD]University[/TD]
[/TR]
[TR]
[TD]Assoc Minho University[/TD]
[TD]Professor[/TD]
[TD]Minho University[/TD]
[/TR]
</tbody>[/TABLE]

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:

[TABLE="width: 845"]
<colgroup><col><col><col span="2"></colgroup><tbody>[TR]
[TD]Description[/TD]
[TD]Job Title[/TD]
[TD="colspan: 2"]University[/TD]
[/TR]
[TR]
[TD]Assoc Prof. Seton Hall University School of Law.[/TD]
[TD]Assoc Prof. [/TD]
[TD="colspan: 2"]Seton Hall University School of Law.[/TD]
[/TR]
[TR]
[TD]Assoc Prof. St. John's.[/TD]
[TD]Assoc Prof. [/TD]
[TD="colspan: 2"]Seton Hall University School of Law.[/TD]
[/TR]
[TR]
[TD]Assoc Prof. St. Mary's University of San Antonio School of Law.[/TD]
[TD]Assoc Prof. [/TD]
[TD="colspan: 2"]Seton Hall University School of Law.[/TD]
[/TR]
[TR]
[TD]Assoc Prof. Stanford. BA, 2000, Cal., Berkeley[/TD]
[TD]Assoc Prof. [/TD]
[TD="colspan: 2"]Seton Hall University School of Law.[/TD]
[/TR]
[TR]
[TD]Assoc Prof. State Univer- sity of New York at Buffalo School of Law.[/TD]
[TD]Assoc Prof. [/TD]
[TD="colspan: 2"]Seton Hall University School of Law.[/TD]
[/TR]
[TR]
[TD]Assoc Prof. The Judge Ad- vocate General's School, U.S. Army. [/TD]
[TD]Assoc Prof. [/TD]
[TD="colspan: 2"]Seton Hall University School of Law.[/TD]
[/TR]
[TR]
[TD]Assoc Prof. Univ. of No. Car..[/TD]
[TD]Assoc Prof. [/TD]
[TD="colspan: 2"]Seton Hall University School of Law.[/TD]
[/TR]
[TR]
[TD]Assoc Prof. University of Miami School of Law.[/TD]
[TD]Assoc Prof. [/TD]
[TD="colspan: 2"]Seton Hall University School of Law.[/TD]
[/TR]
[TR]
[TD]Assoc Prof., George Mason. [/TD]
[TD]Assoc Prof. [/TD]
[TD="colspan: 2"]Seton Hall University School of Law.[/TD]
[/TR]
[TR]
[TD]Assoc Prof., George Mason. AB, 2000, Dartmouth Coll.[/TD]
[TD]Assoc Prof. [/TD]
[TD="colspan: 2"]Seton Hall University School of Law.[/TD]
[/TR]
[TR]
[TD]Assoc Prof., Legal Rea- soning, Res. & Writing. Boston Coll.. [/TD]
[TD]Assoc Prof. [/TD]
[TD="colspan: 2"]Seton Hall University School of Law.[/TD]
[/TR]
</tbody>[/TABLE]

 

[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!