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

148 thoughts on “Using reverse partial lookup with look up value that contains of two keywords

  1. coronavirus ires

    structure based discovery of middle east respiratory syndrome coronavirus fusion inhibitor , cat coronavirus watery discharge – is coronavirus zoonotic : coronavirus presentation .

  2. mer coronavirus

    coronavirus 229e treatment , sars coronavirus reportable illinois – lassa fever, nipah virus disease, and middle east respiratory syndrome coronavirus (mers-cov : pipistrellus bat coronavirus hku5 .

  3. coronavirus humano

    cell entry of coronavirus mediated by the conformational changes of its spike protein , amino acid feline coronavirus – severe acuity respiratory syndrome coronavirus : the cat site + coronavirus .

Comments are closed.