title: Conditional formatting using formula "Vlookup" in google sheet
body: <p>There is a table of values in sheet 1 which I want to conditionally format(Highlight the cells in color
  if the nested value finds a match in the table of sheet 2).</p>
  <p>But it seems like vlookup function couldn't be used in combination with conditional formatting.</p>
  <p>When I put in the formula for format rules(I choose &quot;Custom formula is&quot;),it doesn't work.</p>
  <p>Here is the formula I use.</p>
  <p>Custom formula is &quot;B1=vlookup(B1,Sheet2!$A$1:$A$6,1,false)&quot;</p>
  <p>Is there anything wrong here in this step? Can Vlookup function be used with conditional formatting?</p>
  <p><a href="https://i.stack.imgur.com/EwmvT.png" rel="nofollow noreferrer">A range of cells which I want to conditionally format</a></p>
  <p><a href="https://i.stack.imgur.com/YQ03j.png" rel="nofollow noreferrer">A column of values for looking up </a></p>
  <p><a href="https://i.stack.imgur.com/JYaY6.png" rel="nofollow noreferrer">Vlookup function used with indirect function</a></p>