Retrieving correspondence between two columns to specify another Excel sheet

RodrigoCardoso

New Member
Joined
Dec 7, 2020
Messages
1
Platform
  1. MacOS
Hi everyone

I have a lookup file - see sample 1 - which shows the correspondence between ID codes of universities in Europe (column B) and the EU region code where they are located (column E). I have another file which shows the yearly international student mobility to and from these universities, identified with the same ID codes (columns A and K) - see sample 2. The problem is that in this second file the info about the region is missing. I cannot just copy-paste it because in file no. 2 every individual student is recorded, meaning that each university has hundreds of entries. The total is over 250,000 (all the students moving around Europe in a given year). So, what I need is a way to tell Excel to find in file no. 2 the ID codes of the universities, and then retrieve from file no. 1 the corresponding region code, automatically filling the free columns next to A and K with that information.

Hope this is clear, I would be grateful for some guidance on how to achieve this.
Thanks a lot!
 

Attachments

  • Excel_sample1.png
    Excel_sample1.png
    48.8 KB · Views: 7
  • Excel_sample2.png
    Excel_sample2.png
    112 KB · Views: 7

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

lokayee

New Member
Joined
Jan 3, 2021
Messages
13
Office Version
  1. 365
Platform
  1. Windows
You can create a =vlookup function in column B and L in file 2 to look for the region code of each universities in file 1.
 

Watch MrExcel Video

Forum statistics

Threads
1,129,447
Messages
5,636,328
Members
416,914
Latest member
DWC199

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top