Hi there Brendan and welcome
From what you explained, I believe you need a vlookup?
This looks up a list of values, finds the link and returns a corresponding value.
So you would use something like
=vlookup(Cell with value to compare,where to search,which column number in the search to return)
Is this what you require?