Excel Help comparing 2 columns and return value from 3rd
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
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