title: Matching any cell in one Cell Range with any cell another Cell Range
body: <pre><code>     Col A     |  Col B    |     Col C    |   Col D |       Col E     |
  row1 Roles     |    Create |    Review    | Approve |      Name       |
  row2 PM/Dev/IT |     SQA   |   PM/Dev/IT  |  SQA*   |    Ryan (IT)    |
       PM/Dev    |     SQA   |      N/A     |  SQA    |    Casey (SQA)  |
       PM        |     DEV   |       IT     |  PM     |    Shannon (PM) |
       DEV       |        
       IT        |            
       QA        |            
       SQA       |            
  row8 SQA*      |                
  rw9  SQA**     |                
       Other____ |
  
  rw12 PM        |     CellB13=IF((A13=B2:D2), F4, "N/A")    |        
       SQA       |     CellB14=IF((A13=B2:D2), F5, "N/A")    |
  rw13 IT        |     CellB15=IF((A13=B2:D2), F6, "N/A")    |
  </code></pre>
  
  <p>I want B13 = YES if</p>
  
  <p>If the Role Column is in the Create/Review/orApprove row then display the PM value B13/B14/B15 show the Name Value in the corresponding cell</p>
  
  <p>I want to avoid using VBA for a solution    </p>