Excel Formula - Get Value From Another Excel Sheet Based on Column in Current Sheet
<p>I have two sheets in excel, Summary and Data. The data sheet is connecting through SQL Server and Summary sheet is summarising the data in a table. </p>

<p>Summary sheet </p>

<pre><code>+------+--------------+
| ID   | Month - Year | 
+------+--------------+
|    1 |              |
|    2 |              |     
|    3 |              |  
|    4 |              |   
|    5 |              |
+------+--------------+
</code></pre>

<p>Note: I am using a formula to get the distinct IDs from the data sheet. ID column is column A, Month - Year column is column B. ID 1 is in A2 square.</p>

<p>Data sheet </p>

<pre><code>+------+--------------+
| ID   | Month - Year | 
+------+--------------+
|    1 |  Oct 2014    |
|    2 |  Dec 2014    |    
|    3 |  Oct 2016    | 
|    4 |  Jan 2016    |  
|    5 |  Nov 2015    |
|    6 |  Jul 2015    |  
|    7 |  Jan 2016    |  
|    8 |  Nov 2015    |
|    7 |  Jan 2016    |  
|    8 |  Nov 2015    |
+------+--------------+
</code></pre>

<p>Note: ID  1 is in A2 square, Month - Year is in B2 square. </p>

<p>How do I write a formula for the Summary <strong>Month - Year</strong> column to get each month - year (from data sheet) based on the ID column (in the summary sheet)?</p>

<p>Expected Result:</p>

<pre><code>+------+--------------+
| ID   | Month - Year | 
+------+--------------+
|    1 |  Oct 2014    |
|    2 |  Dec 2014    |    
|    3 |  Oct 2016    | 
|    4 |  Jan 2016    |  
|    5 |  Nov 2015    |
|    6 |  Jul 2015    |  
|    7 |  Jan 2016    |  
|    8 |  Nov 2015    |
+------+--------------+
</code></pre>

<p>Equivalent Expected Result in Pivot Table (with rows Month-Year and ID):</p>

<pre><code>-Nov 2015
--5
--8
-Jan 2016
--4
--7
-Jul 2015
--6
-Oct 2014
--1
-Dec 2014
--2
-Oct 2016
--3
</code></pre>

<p>Effort:
=VLOOKUP(A2,Data!$A$2:$A$500,2,FALSE)</p>