I have four columns, the two in the middle only being there to keep track of other values, not relevant to this.
I'm trying to
- Search for the highest value in, say,
- Get the row of that highest value
- Return the content of the cell
rowbeing the same as found earlier
I already tried
=VLOOKUP like this.
It works until there is no value in
D3:D999 equal to a value in value in
A3:A999, at which point I get an
Additionally, I tried this:
It just showed the highest value it could find in
A3:A999, so no solution either.
EDIT 1: Link to an editable copy of the spreadsheet: here
EDIT 2: I'll leave this spreadsheet accessible if someone else needs it.