Using reverse partial lookup with look up value that contains of two keywords

<!–table {mso-displayed-decimal-separator:”.”; mso-displayed-thousand-separator:”,”;} @page {margin:.75in .7in .75in .7in; mso-header-margin:.3in; mso-footer-margin:.3in;} td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:black; font-size:12.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;} –>



I want the result to be exact match,
meaning the closest match (that contains at least two words) in ‘lookup value’ should be disappear (irrespective of lower/upper case though).
 
In order to be easily understood, here is the link: https://docs.google.com/spreadsheets/d/1TJMk9-XsPKlyBkvPF0NFmbz-h8iE0YcxSucDpIMUUcU/edit#gid=2092897765,
 
 Hope someone can find me solution for the formula that should be use
 
thanks

 

By: freakyholic

Leave a Reply

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