Matching columns of data and returning the value from a column with a value in Excel
<p>Would need help on matching columns in Excel. I have a datasheet in the following order:</p>

<pre><code>Column 1    Column 2    Column 3 
1.1.2015    -           1.1.2015
-           1.1.2013    1.1.2013
-           -           -
</code></pre>

<p>I have data in columns 1 and 2 and would like to lookup the data values from them in column 3. Hence if Column 1 takes on value 1.1.2015 but column 2 takes on value "-" there would be a function in column 3 that returns a value from column 1 when there is a value. And on the next row the same thing but the value that is looked up now is in column 2 as column 1 has a value of "-".  I have a sheet of 15,000 rows so an individual function for each row is not possible. Additionally if both columns 1 &amp; 2 have the value "-" the lookup function should result in a "-" in column 3. I have other variables in addition to dates as well and if there is an function that could handle both dates, numeric values and text values it would be really helpful.</p>

<p>Thanks for any help!</p>