Hello my name is Eddie.
I'm running, Windows 7 with excell 2000.
What I'm trying to do is, looking at b2 match the # with the #'s in cells i1:x1, if found a match, it would return the # thats below it and put the # in cell z2.
Example
b2=2, so it would look at i1:x1, i1 would be correct and so the answer would be 4, and the answer for z2=4.
So any help would be greatly appriciated.
Sincerly Eddie
<b>Excel 2000</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th><th>G</th><th>H</th><th>I</th><th>J</th><th>K</th><th>L</th><th>M</th><th>N</th><th>O</th><th>P</th><th>Q</th><th>R</th><th>S</th><th>T</th><th>U</th><th>V</th><th>W</th><th>X</th><th>Y</th><th>Z</th><th>AA</th><th>AB</th><th>AC</th><th>AD</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;background-color: #C0C0C0;;"></td><td style="background-color: #C0C0C0;;"><4</td><td style="text-align: right;background-color: #C0C0C0;;">2</td><td style="text-align: right;background-color: #C0C0C0;;">6</td><td style="text-align: right;background-color: #C0C0C0;;">9</td><td style="text-align: right;background-color: #C0C0C0;;">11</td><td style="text-align: right;background-color: #C0C0C0;;">14</td><td style="text-align: right;background-color: #C0C0C0;;">17</td><td style="text-align: right;background-color: #C0C0C0;;">19</td><td style="text-align: right;background-color: #C0C0C0;;">22</td><td style="text-align: right;background-color: #C0C0C0;;">23</td><td style="text-align: right;background-color: #C0C0C0;;">25</td><td style="text-align: right;background-color: #C0C0C0;;">26</td><td style="text-align: right;background-color: #C0C0C0;;">27</td><td style="text-align: right;background-color: #C0C0C0;;">32</td><td style="text-align: right;background-color: #C0C0C0;;">34</td><td style="text-align: right;background-color: #C0C0C0;;">35</td><td style="text-align: right;background-color: #C0C0C0;;">36</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="text-align: right;;">1/16</td><td style="text-align: right;;">2</td><td style="text-align: right;;">7</td><td style="text-align: right;;">8</td><td style="text-align: right;;">24</td><td style="text-align: right;;">36</td><td style="text-align: right;background-color: #C0C0C0;;">0</td><td style="text-align: right;background-color: #C0C0C0;;">15</td><td style="text-align: right;;">4</td><td style="text-align: right;;">4</td><td style="text-align: right;;">2</td><td style="text-align: right;;">4</td><td style="text-align: right;;">5</td><td style="text-align: right;;">3</td><td style="text-align: right;;">1</td><td style="text-align: right;;">1</td><td style="text-align: right;;">1</td><td style="text-align: right;;">2</td><td style="text-align: right;;">1</td><td style="text-align: right;;">2</td><td style="text-align: right;;">4</td><td style="text-align: right;;">3</td><td style="text-align: right;;">2</td><td style="text-align: right;;">3</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="text-align: right;;">1/14</td><td style="text-align: right;;">18</td><td style="text-align: right;;">25</td><td style="text-align: right;;">28</td><td style="text-align: right;;">29</td><td style="text-align: right;;">32</td><td style="text-align: right;background-color: #C0C0C0;;">2</td><td style="text-align: right;background-color: #C0C0C0;;">15</td><td style="text-align: right;;">3</td><td style="text-align: right;;">4</td><td style="text-align: right;;">3</td><td style="text-align: right;;">4</td><td style="text-align: right;;">5</td><td style="text-align: right;;">3</td><td style="text-align: right;;">1</td><td style="text-align: right;;">2</td><td style="text-align: right;;">1</td><td style="text-align: right;;">2</td><td style="text-align: right;;">1</td><td style="text-align: right;;">3</td><td style="text-align: right;;">4</td><td style="text-align: right;;">3</td><td style="text-align: right;;">2</td><td style="text-align: right;;">3</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style="text-align: right;;">1/13</td><td style="text-align: right;;">2</td><td style="text-align: right;;">9</td><td style="text-align: right;;">27</td><td style="text-align: right;;">28</td><td style="text-align: right;;">30</td><td style="text-align: right;background-color: #C0C0C0;;">2</td><td style="text-align: right;background-color: #C0C0C0;;">15</td><td style="text-align: right;;">3</td><td style="text-align: right;;">4</td><td style="text-align: right;;">3</td><td style="text-align: right;;">4</td><td style="text-align: right;;">5</td><td style="text-align: right;;">3</td><td style="text-align: right;;">1</td><td style="text-align: right;;">3</td><td style="text-align: right;;">1</td><td style="text-align: right;;">1</td><td style="text-align: right;;">1</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">2</td><td style="text-align: right;;">3</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style="text-align: right;;">1/12</td><td style="text-align: right;;">11</td><td style="text-align: right;;">13</td><td style="text-align: right;;">20</td><td style="text-align: right;;">23</td><td style="text-align: right;;">29</td><td style="text-align: right;background-color: #C0C0C0;;">3</td><td style="text-align: right;background-color: #C0C0C0;;">14</td><td style="text-align: right;;">2</td><td style="text-align: right;;">5</td><td style="text-align: right;;">2</td><td style="text-align: right;;">4</td><td style="text-align: right;;">5</td><td style="text-align: right;;">3</td><td style="text-align: right;;">2</td><td style="text-align: right;;">3</td><td style="text-align: right;;">1</td><td style="text-align: right;;">1</td><td style="text-align: right;;">1</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">2</td><td style="text-align: right;;">3</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Sheet1</p><br /><br />
I'm running, Windows 7 with excell 2000.
What I'm trying to do is, looking at b2 match the # with the #'s in cells i1:x1, if found a match, it would return the # thats below it and put the # in cell z2.
Example
b2=2, so it would look at i1:x1, i1 would be correct and so the answer would be 4, and the answer for z2=4.
So any help would be greatly appriciated.
Sincerly Eddie
<b>Excel 2000</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th><th>G</th><th>H</th><th>I</th><th>J</th><th>K</th><th>L</th><th>M</th><th>N</th><th>O</th><th>P</th><th>Q</th><th>R</th><th>S</th><th>T</th><th>U</th><th>V</th><th>W</th><th>X</th><th>Y</th><th>Z</th><th>AA</th><th>AB</th><th>AC</th><th>AD</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;background-color: #C0C0C0;;"></td><td style="background-color: #C0C0C0;;"><4</td><td style="text-align: right;background-color: #C0C0C0;;">2</td><td style="text-align: right;background-color: #C0C0C0;;">6</td><td style="text-align: right;background-color: #C0C0C0;;">9</td><td style="text-align: right;background-color: #C0C0C0;;">11</td><td style="text-align: right;background-color: #C0C0C0;;">14</td><td style="text-align: right;background-color: #C0C0C0;;">17</td><td style="text-align: right;background-color: #C0C0C0;;">19</td><td style="text-align: right;background-color: #C0C0C0;;">22</td><td style="text-align: right;background-color: #C0C0C0;;">23</td><td style="text-align: right;background-color: #C0C0C0;;">25</td><td style="text-align: right;background-color: #C0C0C0;;">26</td><td style="text-align: right;background-color: #C0C0C0;;">27</td><td style="text-align: right;background-color: #C0C0C0;;">32</td><td style="text-align: right;background-color: #C0C0C0;;">34</td><td style="text-align: right;background-color: #C0C0C0;;">35</td><td style="text-align: right;background-color: #C0C0C0;;">36</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="text-align: right;;">1/16</td><td style="text-align: right;;">2</td><td style="text-align: right;;">7</td><td style="text-align: right;;">8</td><td style="text-align: right;;">24</td><td style="text-align: right;;">36</td><td style="text-align: right;background-color: #C0C0C0;;">0</td><td style="text-align: right;background-color: #C0C0C0;;">15</td><td style="text-align: right;;">4</td><td style="text-align: right;;">4</td><td style="text-align: right;;">2</td><td style="text-align: right;;">4</td><td style="text-align: right;;">5</td><td style="text-align: right;;">3</td><td style="text-align: right;;">1</td><td style="text-align: right;;">1</td><td style="text-align: right;;">1</td><td style="text-align: right;;">2</td><td style="text-align: right;;">1</td><td style="text-align: right;;">2</td><td style="text-align: right;;">4</td><td style="text-align: right;;">3</td><td style="text-align: right;;">2</td><td style="text-align: right;;">3</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="text-align: right;;">1/14</td><td style="text-align: right;;">18</td><td style="text-align: right;;">25</td><td style="text-align: right;;">28</td><td style="text-align: right;;">29</td><td style="text-align: right;;">32</td><td style="text-align: right;background-color: #C0C0C0;;">2</td><td style="text-align: right;background-color: #C0C0C0;;">15</td><td style="text-align: right;;">3</td><td style="text-align: right;;">4</td><td style="text-align: right;;">3</td><td style="text-align: right;;">4</td><td style="text-align: right;;">5</td><td style="text-align: right;;">3</td><td style="text-align: right;;">1</td><td style="text-align: right;;">2</td><td style="text-align: right;;">1</td><td style="text-align: right;;">2</td><td style="text-align: right;;">1</td><td style="text-align: right;;">3</td><td style="text-align: right;;">4</td><td style="text-align: right;;">3</td><td style="text-align: right;;">2</td><td style="text-align: right;;">3</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style="text-align: right;;">1/13</td><td style="text-align: right;;">2</td><td style="text-align: right;;">9</td><td style="text-align: right;;">27</td><td style="text-align: right;;">28</td><td style="text-align: right;;">30</td><td style="text-align: right;background-color: #C0C0C0;;">2</td><td style="text-align: right;background-color: #C0C0C0;;">15</td><td style="text-align: right;;">3</td><td style="text-align: right;;">4</td><td style="text-align: right;;">3</td><td style="text-align: right;;">4</td><td style="text-align: right;;">5</td><td style="text-align: right;;">3</td><td style="text-align: right;;">1</td><td style="text-align: right;;">3</td><td style="text-align: right;;">1</td><td style="text-align: right;;">1</td><td style="text-align: right;;">1</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">2</td><td style="text-align: right;;">3</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style="text-align: right;;">1/12</td><td style="text-align: right;;">11</td><td style="text-align: right;;">13</td><td style="text-align: right;;">20</td><td style="text-align: right;;">23</td><td style="text-align: right;;">29</td><td style="text-align: right;background-color: #C0C0C0;;">3</td><td style="text-align: right;background-color: #C0C0C0;;">14</td><td style="text-align: right;;">2</td><td style="text-align: right;;">5</td><td style="text-align: right;;">2</td><td style="text-align: right;;">4</td><td style="text-align: right;;">5</td><td style="text-align: right;;">3</td><td style="text-align: right;;">2</td><td style="text-align: right;;">3</td><td style="text-align: right;;">1</td><td style="text-align: right;;">1</td><td style="text-align: right;;">1</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">2</td><td style="text-align: right;;">3</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Sheet1</p><br /><br />