Formula to return correlating value and column name

edited 06/17/22 in Formulas and Functions

I've been attempting to construct a formula to find a specific value within a sheet then return it's correlating monetary value along with that value's column name. For instance in the screenshot below I would like to search for the number 7 then return Sep $8. If I have to search for the two separately that is fine. Is this possible?

Many thanks!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!