Currently I use a case statement :
I will eventually have dozens of fields. I am hoping to simplify this with a simple formula. Can I use a formula to simply select the field based on a value of the record. This is similar to using a variable in the column portion of an Excel vlookup.