A VLOOKUP () Can help you in this situation. Try using it like this:
Notice 1 at the end of the Function. This is for Approximate Match. If you make it 0, it will be Exact Match. In your case we want Approximate Match and not Exact Match.
Try this and do write back to us if this was useful.