Formula to return correlating value and column name
jabsneve
✭
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!
Answers

You would need to insert a "helper row" that contains the column names. Then you would use something like this...
=INDEX([Jan]$1:Dec$1, MATCH(7, [M1]$1:[M12]$1, 0)) + " " + INDEX([Jan]@row:Dec@row, MATCH(7, [M1]@row:[M12]@row, 0))v

Thanks Paul. I had to make a few tweaks to your formula but got it to work. Appreciate the help.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!