Looking up values for an array of text

I am looking for an easy way to look up text answers (“I agree”, “I somewhat agree” etc) across various columns with the values for those answers (“I agree” = 4, “I somewhat agree” = 3).
Problem: I have 35 columns with values in it and want to find an effective way to assign the values (which are stored in a separate table).
Thanks, Marlin

Hey there!

I’ve read your post a couple times but am a little confused on your document structure. Can you explain a little more about the structure you are using and what you are trying to accomplish?