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!

Paul Newcome

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

jabsneve

Thanks Paul. I had to make a few tweaks to your formula but got it to work. Appreciate the help.

Paul Newcome

Happy to help. 👍️