Hi everyone,
I have been spending hours trying to figure this one out and I guess I'm just way too much of an Excel newbie to understand, despite having read tutorials, reference pages and such.
What I'm trying to do seems extremely simple (See attached file).
Column A: Keys
Column B: Values
Column E: Lookup values
Column F: There result, minimum value among those whose 'key' match the lookup value in E.
From example, in E1, value is 4. In A, there are 2 occurrences of '4', B3 = 40 and B4 = 10.
Theoretically, I'd expect the formula in F1 to display B4 = 10, but no, it will -always- display the first match occurrence instead of the smallest.
I also tried other things in H, I, J (including IFERROR to clean up bad values) but the end result remains the same.
I'm just it's trivial for you so your help would be much appreciated!
Thanks!
Bookmarks