Index / match

[leopardhawk]

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.

=index(B55:B116,match(year(now)),A55:A116,0))

Column A has years in it and column B has dollar amounts.

Excel 2016 (Windows) 32 bit
	A	B
2	1966	$5,000
3	1967	$5,000
4	1968	$5,100
5	1969	$5,200
6	1970	$5,300
7	1971	$5,400
8	1972	$5,500
9	1973	$5,600
10	1974	$6,600
11	1975	$7,400
12	1976	$8,300
13	1977	$9,300
14	1978	$10,400
15	1979	$11,700
16	1980	$13,100
17	1981	$14,700
18	1982	$16,500
19	1983	$18,500
20	1984	$20,800
21	1985	$23,400
22	1986	$25,800
23	1987	$25,900
24	1988	$26,500
25	1989	$27,700
26	1990	$28,900
27	1991	$30,500
28	1992	$32,200
29	1993	$33,400
30	1994	$34,400
31	1995	$34,900
32	1996	$35,400
33	1997	$35,800
34	1998	$36,900
35	1999	$37,400
36	2000	$37,600
37	2001	$38,300
38	2002	$39,100
39	2003	$39,900
40	2004	$40,500
41	2005	$41,100
42	2006	$42,100
43	2007	$43,700
44	2008	$44,900
45	2009	$46,300
46	2010	$47,200
47	2011	$48,300
48	2012	$50,100
49	2013	$51,100
50	2014	$52,500
51	2015	$53,600
52	2016	$54,900
53	2017	$55,300
54	2018	$55,900
55	2019	$57,400
56	2020
57	2021
58	2022
59	2023
60	2024
61	2025
cpp_web

 

[leopardhawk]

I should have mentioned that I want the formula to return the dollar amount for the current year.

 

[AlanY]

try

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

 

[pike]

one bracket missing
=index(B55:B116,match(year(now()),A55:A116,0))

 

[JefferyLi]

=index(b55:b116,match(year(now()),a55:a116,0))

 

[leopardhawk]

Wow! Thank you all so much. I must have been too tired to notice the missing bracket. Cheers!