title: Vlookup Text Inside Query Results in Google Sheets
body: <p>I'm trying to edit a sheet and use <code>vlookup</code> to get a text from another tab but I'm getting an #N/A error. </p>
  
  <p>What I would like to achieve is to get "March 1st" of the notes tab to G65 of the contacts tab. However, the data in the notes tab from columns A to I is a query from the contacts tab while the "type your notes here" column is not.</p>
  
  <blockquote>
    <p><img src="https://i.stack.imgur.com/Tfn10.png" alt="Contacts tab"></p>
    
    <p><img src="https://i.stack.imgur.com/fw44W.png" alt="Notes tab"></p>
    
    <p><img src="https://i.stack.imgur.com/FfWs8.png" alt="Formula bar shows correct value"></p>
  </blockquote>