Try to match cells and return values

Hello,

I need help!!

I have a table containing the following:

Column A Column B Column C Column D
product Country State Date

I have a second table containing all the Column A and B product and conutry details. I need to compare Columns A and B of the table above to my table, if it matches then look at column C. Depending on the data in C then return the value in column D to my table.

Hope this makes some sort of sense and that someone can help.

Thanks,