title: search value and return adjacent cell
body: <p>Currently I'm learning about functions in Excel, and although it seems rather basic, I can't seem to find the answer to this exercise I was given anywhere.</p>
  
  <p><a href="https://i.stack.imgur.com/NNfmo.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/NNfmo.png" alt="my table"></a></p>
  
  <p>What I'd like to do is use VLOOKUP to find the cell that shows 24000 under "Venta" (C4:C13) and show it's adjacent value under "Vendedor" (B4:B13). Currently I'm trying to use the following function:</p>
  
  <pre><code>=VLOOKUP(IF(C4:C13="24000"),B4:C13,FALSE)
  </code></pre>
  
  <p>...but can't seem to get it to work. I simply get the "problem with this formula" error message.</p>
  
  <p>Sorry for the overall lack of knowledge I have. I'm definitely missing something obvious but, hey, we all start somewhere :/</p>