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% <+10%
Average: Score = 8-15 and Gap >-10% <+10%
Really Good: Score = 16-20 and Gap >20%
Name Score % Gap
Damon, Matt 15 -19%
Cruz, Penelope 13.5 -19%
Lohan, Lindsay 17.5 30%
Johnson, Jack 13 21%
Harper, Ben 13.5 -4%
Blanchett, Cate 15 -19%
Cruise, Tom 20 -5%
Osbourne, Ozzy 17.5 -7%
Gehry, Frank 9 3%
Obama, Barack 12 -17%
Urban, Keith 15 -7%
Thanks in advance for any advice/assistance!
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% <+10%
Average: Score = 8-15 and Gap >-10% <+10%
Really Good: Score = 16-20 and Gap >20%
Name Score % Gap
Damon, Matt 15 -19%
Cruz, Penelope 13.5 -19%
Lohan, Lindsay 17.5 30%
Johnson, Jack 13 21%
Harper, Ben 13.5 -4%
Blanchett, Cate 15 -19%
Cruise, Tom 20 -5%
Osbourne, Ozzy 17.5 -7%
Gehry, Frank 9 3%
Obama, Barack 12 -17%
Urban, Keith 15 -7%
Thanks in advance for any advice/assistance!