Hi,

I have used an array formula to calculate the max value of a column based on a set of criteria e.g. {=MAX('Request List'!AN$3:AN$392)*('Request List'!$E$3:$E$392="Complete")*('Request List'!$F$3:$F$392=Sheet1!$B4)*('Request List'!$A$3:$A$392>=Sheet1!$C$1))}. I now want to find that max value and offset it by x columns to return the text label of who this value refers to. I think I need an index match function combintation but my trial and error has failed so for.

All help gratefully received.

Sarah