title: Nested IF function inside a vlookup for google sheets
body: <p>I'm trying to nest an IF function inside a vlookup to filter data based on a cell in another sheet.</p>
  <p>The ideal functionality would be for the cell to return data if it meets a specific criteria otherwise leave it blank.</p>
  <p>This is what I have so far:</p>
  <p>=IFERROR(vlookup(E2,IF('internal_all[Paste Here]'!H3=&quot;Indexable&quot;,'internal_all[Paste Here]'!A:AB,&quot;&quot;),28,0))</p>
  <p>Currently, it doesn't work but instead I get an error &quot;VLOOKUP equates to an out of bounds range&quot;.</p>
  <p>Any help would be much appreciated.</p>
  <p>Here's a copy of my gsheet: <a href="https://docs.google.com/spreadsheets/d/13mcOOHIP6-YQKOhE_LHnmu3-7bSNKzvCSTVZ5BnTxPA/edit#gid=0" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/13mcOOHIP6-YQKOhE_LHnmu3-7bSNKzvCSTVZ5BnTxPA/edit#gid=0</a></p>
  <p>Here's an example of the error I'm running into:
  <a href="https://i.stack.imgur.com/KLunZ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/KLunZ.png" alt="enter image description here" /></a></p>