Hi @himicanuck - this sounds similar to a VLOOKUP - we have an example of how to do this here:
Let us know if you have any follow-up questions!