Join based on range

[nolatraveigirl]

I am trying to join the first two tables and get the results like the third table. Any help would be appreciated.

From	To	Option
1900	2017	A
2018	2020	B
2019	2099	A

Year	Description	Amount
2015	Book	500.00
2018	Shelves	1,000.00
2017	Equipment	75.00
2020	Chairs	50.00
2021	Desks	65.00

Year	Description	Amount
2015	Book	500.00	A
2018	Shelves	1,000.00	B
2017	Equipment	75.00	A
2020	Chairs	50.00	A
2021	Desks	65.00	A

[alexnajm]

Have you tried the Join on ranges macro?