Taking correspondence between 2 columns to specify another Excel sheet
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!
Re: Taking correspondence between 2 columns to specify another Excel sheet
See formulae in column B (and L):
This includes the local filepath because that's how Excel saves formulae when th data comes from another file. You need to do one of two things:
either amend the formula so that the file paths are correct, or, easier, have both files open when the formula can be in the shorter form:
(you still have to get the file name right both times).
Currently they're all showing errors because (a) the file they're looking for isn't there and (b) there's no matching data at all in the files you supplied.
To prevent the continued reliance on the presence of the other file, you should copy/paste-special |Values in situ to convert the results of the formulae to plain values.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By nicks1 in forum Excel Programming / VBA / Macros
Last Post: 12-10-2018, 11:35 AM
By mrsak87 in forum Excel General
Last Post: 10-06-2018, 12:52 AM
By Dost.Rehman in forum Excel Programming / VBA / Macros
Last Post: 10-24-2017, 02:45 AM
By slamdunka in forum Excel Programming / VBA / Macros
Last Post: 02-25-2015, 02:32 AM
By Mr.West in forum Excel Formulas & Functions
Last Post: 02-09-2014, 05:14 PM
By missf in forum Excel Programming / VBA / Macros
Last Post: 06-06-2011, 04:46 AM
By darklide in forum Excel Programming / VBA / Macros
Last Post: 03-13-2010, 03:59 PM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1