Forum Discussion
Returning a text value from an array
I have a large spreadsheet that has names in column a, dates in column b, positions in column c, and then columns of test results in d-az. I can search through and find results the record holder for ...
Thank you for the help. You got me on the right track. It didn't match exactly, but the final solution that worked was:
=INDEX(DATABASE!$A:$A,MATCH(1,(DATABASE!$B:$B=MAX(IF((DATABASE!$AW:$AW=B145)*(DATABASE!$C:$C="L"),(DATABASE!$B:$B))))*(DATABASE!$AW:$AW=B145)*(DATABASE!$C:$C="L"),0))
Thank you again!!
Hi Jerome,
Glad to know you sorted this out. Just in case, i compared both formulas (only changed in my AX on AW), they give the same result - see attached.