title: Search for value, return value in adjacent cell
body: <p>I am not good with the advanced Excel stuff, and I've got something which appears to be a VLOOKUP question (which I have never used before).</p>
  
  <p>The situation is such. I need to search for a specific value in six columns of a sheet and return the value of the cell adjacent to the right. So far I have a-googled many options, none of which work, although I did get ISERROR to work and tell me there's no match (which is wrong).</p>
  
  <p>In fact, here is that one, which seems most promising:</p>
  
  <pre><code>=IF(ISERROR(MATCH(2013,I2:N433,0)), "No Match", VLOOKUP(2013,J2:N433,+1,FALSE))
  </code></pre>
  
  <p>Here's is what I think it is doing:</p>
  
  <ul>
  <li>The IF gets it rolling</li>
  <li>ISERROR is returning "No match" if the criteria are not met...</li>
  <li>...which should be the MATCH section, searching for 2013 in the range J2:N433, 0 for exact</li>
  <li>...and if the criteria are met, then the VLOOKUP is looking for 2013 in the array J2:N433</li>
  <li>...putting in the +1 to return the value of one column over</li>
  <li>...and FALSE used for an exact match</li>
  </ul>
  
  <p>So I think the +1 is a sticking point. I read a post on here or excelforum.com saying that when using a MATCH, +1 increments one column, but that just seems too loose for Excel.</p>
  
  <p>To be honest, I have read a lot of posts over the past two hours, and they're all jumbled in  my head. I figured I'd just head right to here and see who can un-jumble my ideas.</p>
  
  <p>Thanks very much. I am using Mac Excel 2011.</p>
  
  <p>EDIT: Here is a chunk of my data.</p>
  
  <pre><code>2011    6   2012    5   2013    6   2014    57
  2011    6   2012    5   2013    6   2014    57
  2011    11  2012    10  2013    11  2014    62
  2010    11  2011    10  2012    11  2013    62
  2010    11  2011    10  2012    11  2013    62
  </code></pre>
  
  <p>What I wish to see is be able to make another column that finds the 2013s then displays the value to their right, such as 6, 11, 62, etc.</p>
  
  <p>EDIT 2: I added the above data upon Werner's request as you don't get new lines in comments. When I did that, I apparently lost the answer thread...? Annoying. Sorry, I didn't think that would happen.</p>