Forum Discussion
Solved
Sort data if rank is found with RANK formula
Good morning, I have a project I am completing and the final step is to get the date shown in the sample file to sort based on the numbered rank under the "RANK" column that is populated using th...
Have you tried using XLOOKUP (or INDEX/MATCH) to look up the Vendor and Percentage based on the rank? E.g.
=XLOOKUP(F18,$X$2:$X$12,$V$2:$V$12)
=XLOOKUP(F18,$X$2:$X$12,$W$2:$V$12)
or
=INDEX($V$2:$V$12,MATCH(F18,$X$2;$X$18,0))
=INDEX($W$2:$W$12,MATCH(F18,$X$2;$X$18,0))
Have you tried using XLOOKUP (or INDEX/MATCH) to look up the Vendor and Percentage based on the rank? E.g.
=XLOOKUP(F18,$X$2:$X$12,$V$2:$V$12)
=XLOOKUP(F18,$X$2:$X$12,$W$2:$V$12)
or
=INDEX($V$2:$V$12,MATCH(F18,$X$2;$X$18,0))
=INDEX($W$2:$W$12,MATCH(F18,$X$2;$X$18,0))
- XLOOKUP worked perfectly, thank you!!
