Hi all,
I am despreately looking for a solution to my issue in order to complete a panel data set. I tried already vlookup, index,match but could not really find a work around. I hope you can help me, preferebly with a formula instead of VBA :)
My issue:
I would like to fill C2 from the sheet "Panel dataset" with B2 form the sheet "Debt to GDP". Since my dataset is much much bigger than the example I am looking for a forumla that fills C2 if a cell in "Debt to GDP" matches with the country (Albania) and the year (2001) in both sheets.
Hope you can help me out.
Best wishes and many thanks!
ps. I work in Office 365
Bookmarks