Hi All, I have a table with rank numbers. (B2:U25) Some ranks are the same within a column (so 2 rank 2's as in Column D - rows 14 and 19)
From the ranks, I lookup the value in column V.
In rows 28, 29 and 30 I use the lookup for the first 3 ranks.
I have attached a sheet as an example.
The problem is like in column D, I have 1 rank 1, 2 ranks 2's and 0 rank 3's. Using HLOOKUP it only finds the first rank 2. How can I also find the 2nd rank 2?
Bookmarks