Excel Help comparing 2 columns and return value from 3rd

Job ID: 33883215

Budget: $10 – $30 USD

I have the below table

A. B. C
5045460249175 5045461517297 2
5045461283864 5045460249175 3
5045461517297 5045461283864 4

I need to check column A compare it with Coloum B, and return the appropriate value from C into D

In this instance 5045460249175 will return 3 into column D

Please can you help

Thanks
Related categories: Excel Microsoft