Formula to return correlating value and column name
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?
Help Article Resources
Check out the Formula Handbook template!