Index Match Based on Ratio of Two Columns

I've attached the book. I don't want to augment my sheet with a column to run the ratio calculation. I know how to return the max ratio via an array formula, but I can't get it to work with a combination of match, offset, index, etc. It doesn't have to be an array formula either, Im sure it can be done without it, too.

Thanks in advance!

Yahtzee! Man, I've been keying away at this one for an hour, thank you so much!

Any hints on how to do it without using an array?

It also works without them being locked.

It's only working as an array.

No worries, I was thinking at first there may be an algebraic manipulation I could make to get the answer, but that would also need an array.

Originally Posted by FlameRetired

Actually I am puzzling away at that one right now. Hope you caught my earlier INDEX error.

No worries, I was thinking at first there may be an algebraic manipulation I could make to get the answer, but that would also need an array.

Originally Posted by FlameRetired

Still an array this version does not have to be committed with CSE. Simple Enter works.

Formula:

Please Login or Register  to view this content.

Awesome... I tried the index(match(max(... 100 times, but my mistake was not setting the lookup as the ratio. I was setting the lookup array as D2:E7.

Now, that extra comma in there, I need to figure out what that guy is doing, but otherwise, you're a pro!