title: VLOOKUP function in LibreOffice to identify and map two values for 1 label
body: <p>I've been <a href="http://classroom.synonym.com/use-vlookup-matching-data-10893.html" rel="nofollow noreferrer">searching</a> <a href="https://help.libreoffice.org/Calc/Spreadsheet_Functions" rel="nofollow noreferrer">many</a> <a href="https://www.youtube.com/watch?v=WoHWWwUN9Uo" rel="nofollow noreferrer">examples</a> of <code>VLOOKUP</code>, with application to LibreOffice, what I'd like to do is unify a set of sheets by a common value. </p>
  
  <p>The information on the two sheets is different, and in fact, each value on the one sheet will be repeated twice on the other, as such, we will have it that, in essence the first sheet <code>Sheet 1</code> will look more or less like this: </p>
  
  <p><a href="https://i.stack.imgur.com/xDQw3.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/xDQw3.png" alt="enter image description here"></a></p>
  
  <p>and the second, <code>Sheet 2</code>, looks like this: </p>
  
  <p><a href="https://i.stack.imgur.com/3klpd.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/3klpd.png" alt="enter image description here"></a></p>
  
  <p>as you can see, for the column <code>submission #</code> in the pink sheet, <code>Sheet 1</code>, the value of <code>4</code> is repeated twice in <code>Sheet 2</code>, the purple one, i.e. the first two entries are both characterized by the value <code>4</code> in the column <code>submission #</code>.</p>
  
  <p>Initially I was thinking that I might but the values, all the values, from the purple sheet, <code>Sheet 2</code>, along side the associated <code>submission #</code> index of the pink sheet <code>Sheet 1</code>, in this way: </p>
  
  <p><a href="https://i.stack.imgur.com/ujkDN.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ujkDN.png" alt="enter image description here"></a> </p>
  
  <p>But it could also work that the <code>submission #</code> column with the value of <code>4</code> from the pink sheet is conjoined twice onto the <code>Sheet 2</code>, purple sheet. </p>
  
  <p>As I said, I've been battling with the "Function generator" button located on the dashboard of LibreOffice to no avail. </p>
  
  <p>How to structure such a function?</p>