Index/Match

[Misterchipper]

I have 2 separate lists, both looking similar to the example below. Pulling this data using vlookup is very easy--however, vlookups seems to be slowing down my computer greatly. I am trying to pull data from both of these lists into a master list. One set of data contains sales by month. The other set contains units by month.

As such, I am trying to use Index/Match. I am not able to get over the last hurdle. Could someone please help? I would like the Index/Match to automatically pull the respective sales for each month--i.e. I don't have to type in a column number like I do with vlookups. Is this possible? I am still slightly confused as to how index/match works, and none of the tutorials seem to be help.

Thanks in advance.



<table border="0" cellpadding="0" cellspacing="0" width="256"><col style="width: 48pt;" width="64" span="4"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl68" style="height: 15pt; width: 48pt;" width="64" height="20">Number</td> <td class="xl69" style="width: 48pt;" align="right" width="64">Jan-10</td> <td class="xl69" style="width: 48pt;" align="right" width="64">Feb-10</td> <td class="xl69" style="width: 48pt;" align="right" width="64">Mar-10</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl68" style="height: 15pt;" align="right" height="20">8</td> <td class="xl68"> </td> <td class="xl68"> </td> <td class="xl68"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl68" style="height: 15pt;" align="right" height="20">4</td> <td class="xl68"> </td> <td class="xl68"> </td> <td class="xl68"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl68" style="height: 15pt;" align="right" height="20">3</td> <td class="xl68"> </td> <td class="xl68"> </td> <td class="xl68"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl68" style="height: 15pt;" align="right" height="20">6</td> <td class="xl68"> </td> <td class="xl68"> </td> <td class="xl68"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl68" style="height: 15pt;" align="right" height="20">1</td> <td class="xl68"> </td> <td class="xl68"> </td> <td class="xl68"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl68" style="height: 15pt;" align="right" height="20">2</td> <td class="xl68"> </td> <td class="xl68"> </td> <td class="xl68"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl68" style="height: 15pt;" align="right" height="20">7</td> <td class="xl68"> </td> <td class="xl68"> </td> <td class="xl68"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl68" style="height: 15pt;" align="right" height="20">5</td> <td class="xl68"> </td> <td class="xl68"> </td> <td class="xl68"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl68" style="height: 15pt;" align="right" height="20">9</td> <td class="xl68"> </td> <td class="xl68"> </td> <td class="xl68"> </td> </tr> </tbody></table>

 

[Andrew Poulsom]

Does this example help you?

http://www.contextures.com/xlFunctions03.html#IndexMatch2

 

[Misterchipper]

That is the example that I was using, but it still confuses me because I am not doing exactly the same thing as in the report.

As my data will me matching to "Number" horizontally and "Date" Vertically.


Number Jan10 February 10
8
3
6
5

 

[Andrew Poulsom]

Your table seems to have numbers vertically and dates horizontally. The second and third arguments for INDEX are row-index and column-index respectively.

If you are still stuck post some sample data and give an example of what you want the formula to return.

 

[Misterchipper]

Jackpot. Figured it out. Thanks again for your help.