Quote Originally Posted by Excel Fox View Post
Hi soltec. Welcome to the ExcelFox community.

Could a formula based solution work (one solution provided), or would you need to do this using VBA?
VLookup would do what is needed I believe.