I need to have excel automatically pull data from the second sheet into the first sheet. I have manually selected the data in column E as an example. I need column E to show GDP per capita for the country in column A and year in column C. Thank you very much!
See attached for formula. It's an INDEX/MATCH/MATCH formula, used to look up in a matrix using column and row headings. This assumes that the column headings on Data are always of the form
yyyy [YRyyyy]
Note that you have duplicate countries in your list so you will get the results for every row for, say, Algeria.
Gambia is an error because there is no 2006 available, Iraq/2013, Morocco/2011
Country names must match exactly. Indonesia and Laos did not match because you had an extra space at the end of the country name on Sheet1
Thank you, worked perfectly. Also thanks for flagging the inconsistencies due to different years/country names.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks