title: Excel Formula Similar to Select-Case
body: <p>I have five columns of data (A-E), most of which are blank. In column F, I want to display one value from the 5 cells in that row. Specifically, I want to display the rightmost cell with a value. For example, if A3 and D3 both have values, then it should populate with D3. If only B4 has a value, then I'd like that value. They all have formulas in them, but most of the formulas result in blanks.</p>
  
  <p>I suspect this could be accomplished with nested IFs, but I'm hoping for a more concise way.</p>