title: Lookup a value that matches a key in one column then apply that as a key to return a value from a third column
body: <p>I have values in columns G and N that have the same values, but not in the same order, so if column G and N matches, then return column L to column A. I am getting the wrong values from column L in column A.</p>
  
  <p>What other information is needed besides formula below? </p>
  
  <pre><code>=IFERROR(VLOOKUP(N2,$G$2:$N$413,6,FALSE),"")  
  </code></pre>
  
  <pre>Col a      Col b    Col G    Col L   Col M    Col N
      ID     CoID     Items    ItemsID ParentID Items1
      45     1        Apple    45      1        Apple</pre>