manoj18071965
Board Regular
- Joined
- Sep 16, 2011
- Messages
- 65
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:
<tbody>
</tbody>
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>