VLOOKUP Values with GREATER THAN RULES

Please help. I’m seeking to VLOOKUP the values, as such. 

<!–table {mso-displayed-decimal-separator:”.”; mso-displayed-thousand-separator:”,”;} @page {margin:.75in .7in .75in .7in; mso-header-margin:.3in; mso-footer-margin:.3in;} tr {mso-height-source:auto;} col {mso-width-source:auto;} br {mso-data-placement:same-cell;} td {padding:0px; mso-ignore:padding; color:black; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked visible; white-space:nowrap; mso-rotate:0;} .xl63 {font-weight:700;} .xl64 {mso-number-format:0%;} –>



Sample Data          
           
  Apples Oranges Bananas Peaches Berries
Boston 24% 16% 18% 23% 17%
Philadelphia 21% 21% 21% 17% 16%
New York 20% 21% 17% 18% 17%
Richmond 18% 19% 24% 19% 18%
Baltimore 17% 15% 19% 21% 20%
           
Rules          
           
Boston Return MAX Value if Greater Than 23% with label, otherwise state ‘balanced’
Philadelphia Return MAX Value if Greater Than 21% with label, otherwise state ‘balanced’
New York Return MAX Value if Greater Than 20% with label, otherwise state ‘balanced’
Richmond Return MAX Value if Greater Than 20% with label, otherwise state ‘balanced’
Baltimore Return MAX Value if Greater Than 19% with label, otherwise state ‘balanced’
           
Ideal Answer Format        
           
City Maximum Fruit      
Boston  Apples        
Philadelphia Balanced        
New York Oranges        
Richmond Bananas        
Baltimore Peaches        

By: frustratedworker

Leave a Reply

Your email address will not be published. Required fields are marked *