title: outer join in MS Excel
body: <p>do you have an idea how to join two tables with the outer join ? Know to do this in SQL, but I need Excel now.</p>
  
  <p>I have a list of all employees in one column
  I have a table of task for every employee. I would like to create a function, that will populate this table with missing employees.</p>
  
  <p>Table 1 - list of all employees</p>
  
  <pre>
  Fernando
  Hector
  Vivian
  Ivan
  </pre>
  
  <p>Table 2 - list of actual tasks</p>
  
  <pre>
  Fernando, task A, 5 hours
  Vivian, task B, 8 hours
  </pre>
  
  <p>Result I would like to achieve</p>
  
  <pre>
  Fernando, task A, 5 hours
  Vivian, task B, 8 hours
  Hector, , 0 hours
  Ivan, , 0 hours
  </pre>
  
  <p>Thanks a lot for any ideas.</p>