I am trying to use VLookup to sort data based on two value criteria. I've tried Lookup, VLookup, Index/Match without any luck.
If this is my data, I need to sort these names using the following criteria:
Really Bad: Score = 0-7 and Gap <10%
Sort of Bad: Score = 0-7 and Gap >-10%...