V look up help needed

manoj18071965

Board Regular
Joined
Sep 16, 2011
Messages
62
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>
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

tico_ocit

Board Regular
Joined
Apr 5, 2019
Messages
95
Code:
=VLOOKUP($A$2,Sheet2!$A$2:$C$10,2,FALSE)
- Job Titles
Code:
=VLOOKUP($A$2,Sheet2!$A$2:$C$10,3,FALSE)
- University

Sheet1
DescriptionJob TitleUniversity
Assoc Minho UniversityProfessorMinho University

<tbody>
</tbody>

Sheet2
DescriptionJob TitleUniversity
Assoc Minho UniversityProfessorMinho 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?
 
Last edited:

manoj18071965

Board Regular
Joined
Sep 16, 2011
Messages
62
It doesnot solved the purpose. by using this formula values are displaying as stated below:

DescriptionJob TitleUniversity
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., BerkeleyAssoc 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

Board Regular
Joined
Sep 16, 2011
Messages
62
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)
 

Watch MrExcel Video

Forum statistics

Threads
1,114,614
Messages
5,549,012
Members
410,889
Latest member
laingwb
Top