LinkBack URL
About LinkBacks
Just to avoid OFFSET, I'd use:
=INDEX($A$10:$A$15,MATCH(MAX(INDEX($B$10:$E$15,,MATCH(B3,$B$9:$E$9,0))),INDEX($B$10:$E$15,,MATCH(B3,$B$9:$E$9,0)),0))
You could shorten it with a helper cell storing the MATCH(B3,$B$9:$E$9,0) part.
Just to avoid OFFSET, I'd use:
=INDEX($A$10:$A$15,MATCH(MAX(INDEX($B$10:$E$15,,MATCH(B3,$B$9:$E$9,0))),INDEX($B$10:$E$15,,MATCH(B3,$B$9:$E$9,0)),0))
You could shorten it with a helper cell storing the MATCH(B3,$B$9:$E$9,0) part.
Everyone who confuses correlation and causation ends up dead.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks