Hi, I'm a bit stuck on how to merge some of my data, so hopefully someone out there can help

I have two worksheets. I want to create a new column ("NEW COLUMN") in sheet1 where if column A and column B in sheets 1 and 2 match, I want it to return column C from sheet 2 into "NEW COLUMN."

Basically, I have every country-years in 1 sheet (i.e., Albania 1970, Albania 1971, Albania 1972, etc etc where each of those is its own row, and the country is column A and the year is Column B) with the GNI for each country-year in column C. Then in another sheet I have only specific country-years (i.e., Albania 1970, Albania 1982, Albania 1991, etc) with the amount of foreign aid received that year. I want my new column that I create to match on country and year and import my specific foreign aid information into the column (since GNI exists for every country year, but foreign aid only occurs for specific country years).

Is there a way to merge this based on those conditions?

Thanks in advance for your help!!
-gth843a