Data Transformation in Pipeline

One way is to make a translation table. The key field will be the Salesforce value. The other field will be the QuickBase value. 

Then I would make a relationship where one salesforce values record has many QuickBase data records.  I would let the system create a Field called Related Salesforce value and  then I would change that field to a formula text field equal to the value of the field  in the Quickbase data, which holds the salesforce value.  The reason I wanna formula is because if anybody is manually editing I don't think you want them choosing off up that table, but I guess that's up to you whether you want users to be able to do manual entry. It sounds like your  Quickbase QuickBase data is imported. .