• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Lookup title of a table column in another sheet (with worksheet attached)

sampahmel

New Member
Hi all,

I'm looking for a method to capture the title of a column in a sheet via the formula/data used to calculate averages in another sheet.

Please find attached an example worksheet with my problem illustrated.
 

Attachments

  • Book1.xlsx
    12.5 KB · Views: 4
Or Something like this....
Code:
=IFERROR(IF(INDEX($C$5:$C$6,MATCH(MAX(D5:D6),D5:D6,0))="Male","Mike","Joanne"),"")
 
Thanks Narayan for your solution.

But I just realised that my problem is more complex.

I was hoping that we could return the name in row 3 (of sheet2) based on the formula in row 5 and 6 (of sheet 1).
 
Back
Top