HLookup work around

I'm brand new to Smartsheet and trying to figure out the best (most elegant) solution to get the result illustrated in the screenshot below. Any help/suggestions would be most appreciated. TIA



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!