Index / match

leopardhawk

Active Member
Joined
May 31, 2007
Messages
428
Office Version
2016
Platform
Windows
Hello forum friends, can someone please tell me what is wrong with this formula? I keep getting the error that I have entered too few arguments.

Code:
=index(B55:B116,match(year(now)),A55:A116,0))
Column A has years in it and column B has dollar amounts.

<b>Excel 2016 (Windows) 32 bit</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #B6AAA6"><colgroup><col width="25px" style="background-color: #E0E0F0 " /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0 ;text-align: center;color: #201116"><th></th><th>A</th><th>B</th></tr></thead><tbody><tr ><td style="color: #201116;text-align: center;">2</td><td style="text-align: right;;">1966</td><td style="text-align: right;;">$5,000</td></tr><tr ><td style="color: #201116;text-align: center;">3</td><td style="text-align: right;;">1967</td><td style="text-align: right;;">$5,000</td></tr><tr ><td style="color: #201116;text-align: center;">4</td><td style="text-align: right;;">1968</td><td style="text-align: right;;">$5,100</td></tr><tr ><td style="color: #201116;text-align: center;">5</td><td style="text-align: right;;">1969</td><td style="text-align: right;;">$5,200</td></tr><tr ><td style="color: #201116;text-align: center;">6</td><td style="text-align: right;;">1970</td><td style="text-align: right;;">$5,300</td></tr><tr ><td style="color: #201116;text-align: center;">7</td><td style="text-align: right;;">1971</td><td style="text-align: right;;">$5,400</td></tr><tr ><td style="color: #201116;text-align: center;">8</td><td style="text-align: right;;">1972</td><td style="text-align: right;;">$5,500</td></tr><tr ><td style="color: #201116;text-align: center;">9</td><td style="text-align: right;;">1973</td><td style="text-align: right;;">$5,600</td></tr><tr ><td style="color: #201116;text-align: center;">10</td><td style="text-align: right;;">1974</td><td style="text-align: right;;">$6,600</td></tr><tr ><td style="color: #201116;text-align: center;">11</td><td style="text-align: right;;">1975</td><td style="text-align: right;;">$7,400</td></tr><tr ><td style="color: #201116;text-align: center;">12</td><td style="text-align: right;;">1976</td><td style="text-align: right;;">$8,300</td></tr><tr ><td style="color: #201116;text-align: center;">13</td><td style="text-align: right;;">1977</td><td style="text-align: right;;">$9,300</td></tr><tr ><td style="color: #201116;text-align: center;">14</td><td style="text-align: right;;">1978</td><td style="text-align: right;;">$10,400</td></tr><tr ><td style="color: #201116;text-align: center;">15</td><td style="text-align: right;;">1979</td><td style="text-align: right;;">$11,700</td></tr><tr ><td style="color: #201116;text-align: center;">16</td><td style="text-align: right;;">1980</td><td style="text-align: right;;">$13,100</td></tr><tr ><td style="color: #201116;text-align: center;">17</td><td style="text-align: right;;">1981</td><td style="text-align: right;;">$14,700</td></tr><tr ><td style="color: #201116;text-align: center;">18</td><td style="text-align: right;;">1982</td><td style="text-align: right;;">$16,500</td></tr><tr ><td style="color: #201116;text-align: center;">19</td><td style="text-align: right;;">1983</td><td style="text-align: right;;">$18,500</td></tr><tr ><td style="color: #201116;text-align: center;">20</td><td style="text-align: right;;">1984</td><td style="text-align: right;;">$20,800</td></tr><tr ><td style="color: #201116;text-align: center;">21</td><td style="text-align: right;;">1985</td><td style="text-align: right;;">$23,400</td></tr><tr ><td style="color: #201116;text-align: center;">22</td><td style="text-align: right;;">1986</td><td style="text-align: right;;">$25,800</td></tr><tr ><td style="color: #201116;text-align: center;">23</td><td style="text-align: right;;">1987</td><td style="text-align: right;;">$25,900</td></tr><tr ><td style="color: #201116;text-align: center;">24</td><td style="text-align: right;;">1988</td><td style="text-align: right;;">$26,500</td></tr><tr ><td style="color: #201116;text-align: center;">25</td><td style="text-align: right;;">1989</td><td style="text-align: right;;">$27,700</td></tr><tr ><td style="color: #201116;text-align: center;">26</td><td style="text-align: right;;">1990</td><td style="text-align: right;;">$28,900</td></tr><tr ><td style="color: #201116;text-align: center;">27</td><td style="text-align: right;;">1991</td><td style="text-align: right;;">$30,500</td></tr><tr ><td style="color: #201116;text-align: center;">28</td><td style="text-align: right;;">1992</td><td style="text-align: right;;">$32,200</td></tr><tr ><td style="color: #201116;text-align: center;">29</td><td style="text-align: right;;">1993</td><td style="text-align: right;;">$33,400</td></tr><tr ><td style="color: #201116;text-align: center;">30</td><td style="text-align: right;;">1994</td><td style="text-align: right;;">$34,400</td></tr><tr ><td style="color: #201116;text-align: center;">31</td><td style="text-align: right;;">1995</td><td style="text-align: right;;">$34,900</td></tr><tr ><td style="color: #201116;text-align: center;">32</td><td style="text-align: right;;">1996</td><td style="text-align: right;;">$35,400</td></tr><tr ><td style="color: #201116;text-align: center;">33</td><td style="text-align: right;;">1997</td><td style="text-align: right;;">$35,800</td></tr><tr ><td style="color: #201116;text-align: center;">34</td><td style="text-align: right;;">1998</td><td style="text-align: right;;">$36,900</td></tr><tr ><td style="color: #201116;text-align: center;">35</td><td style="text-align: right;;">1999</td><td style="text-align: right;;">$37,400</td></tr><tr ><td style="color: #201116;text-align: center;">36</td><td style="text-align: right;;">2000</td><td style="text-align: right;;">$37,600</td></tr><tr ><td style="color: #201116;text-align: center;">37</td><td style="text-align: right;;">2001</td><td style="text-align: right;;">$38,300</td></tr><tr ><td style="color: #201116;text-align: center;">38</td><td style="text-align: right;;">2002</td><td style="text-align: right;;">$39,100</td></tr><tr ><td style="color: #201116;text-align: center;">39</td><td style="text-align: right;;">2003</td><td style="text-align: right;;">$39,900</td></tr><tr ><td style="color: #201116;text-align: center;">40</td><td style="text-align: right;;">2004</td><td style="text-align: right;;">$40,500</td></tr><tr ><td style="color: #201116;text-align: center;">41</td><td style="text-align: right;;">2005</td><td style="text-align: right;;">$41,100</td></tr><tr ><td style="color: #201116;text-align: center;">42</td><td style="text-align: right;;">2006</td><td style="text-align: right;;">$42,100</td></tr><tr ><td style="color: #201116;text-align: center;">43</td><td style="text-align: right;;">2007</td><td style="text-align: right;;">$43,700</td></tr><tr ><td style="color: #201116;text-align: center;">44</td><td style="text-align: right;;">2008</td><td style="text-align: right;;">$44,900</td></tr><tr ><td style="color: #201116;text-align: center;">45</td><td style="text-align: right;;">2009</td><td style="text-align: right;;">$46,300</td></tr><tr ><td style="color: #201116;text-align: center;">46</td><td style="text-align: right;;">2010</td><td style="text-align: right;;">$47,200</td></tr><tr ><td style="color: #201116;text-align: center;">47</td><td style="text-align: right;;">2011</td><td style="text-align: right;;">$48,300</td></tr><tr ><td style="color: #201116;text-align: center;">48</td><td style="text-align: right;;">2012</td><td style="text-align: right;;">$50,100</td></tr><tr ><td style="color: #201116;text-align: center;">49</td><td style="text-align: right;;">2013</td><td style="text-align: right;;">$51,100</td></tr><tr ><td style="color: #201116;text-align: center;">50</td><td style="text-align: right;;">2014</td><td style="text-align: right;;">$52,500</td></tr><tr ><td style="color: #201116;text-align: center;">51</td><td style="text-align: right;;">2015</td><td style="text-align: right;;">$53,600</td></tr><tr ><td style="color: #201116;text-align: center;">52</td><td style="text-align: right;;">2016</td><td style="text-align: right;;">$54,900</td></tr><tr ><td style="color: #201116;text-align: center;">53</td><td style="text-align: right;;">2017</td><td style="text-align: right;;">$55,300</td></tr><tr ><td style="color: #201116;text-align: center;">54</td><td style="text-align: right;;">2018</td><td style="text-align: right;;">$55,900</td></tr><tr ><td style="color: #201116;text-align: center;">55</td><td style="text-align: right;;">2019</td><td style="text-align: right;;">$57,400</td></tr><tr ><td style="color: #201116;text-align: center;">56</td><td style="text-align: right;;">2020</td><td style="text-align: right;;"></td></tr><tr ><td style="color: #201116;text-align: center;">57</td><td style="text-align: right;;">2021</td><td style="text-align: right;;"></td></tr><tr ><td style="color: #201116;text-align: center;">58</td><td style="text-align: right;;">2022</td><td style="text-align: right;;"></td></tr><tr ><td style="color: #201116;text-align: center;">59</td><td style="text-align: right;;">2023</td><td style="text-align: right;;"></td></tr><tr ><td style="color: #201116;text-align: center;">60</td><td style="text-align: right;;">2024</td><td style="text-align: right;;"></td></tr><tr ><td style="color: #201116;text-align: center;">61</td><td style="text-align: right;;">2025</td><td style="text-align: right;;"></td></tr></tbody></table><p style="width:4.2em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #B6AAA6;border-top:none;text-align: center;background-color: #E0E0F0 ;color: #201116">cpp_web</p><br /><br />
 

Some videos you may like

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

leopardhawk

Active Member
Joined
May 31, 2007
Messages
428
Office Version
2016
Platform
Windows
I should have mentioned that I want the formula to return the dollar amount for the current year.
 

AlanY

Well-known Member
Joined
Oct 30, 2014
Messages
3,981
Office Version
365, 2019, 2016
Platform
Windows
try

=INDEX(B1:B116,MATCH(YEAR(TODAY()),A1:A116,0))
 
Last edited:

leopardhawk

Active Member
Joined
May 31, 2007
Messages
428
Office Version
2016
Platform
Windows
Wow! Thank you all so much. I must have been too tired to notice the missing bracket. Cheers!
 

Watch MrExcel Video

Forum statistics

Threads
1,099,684
Messages
5,470,114
Members
406,681
Latest member
sachinmasurkar

This Week's Hot Topics

Top