Welcome to the forum.

Have a look at the VLOOKUP() worksheet function in the Excel helpfile. Once you've read the helpfile topic, please feel free to post back if you're not sure how to use it and we can try to help some more.