Dropdown and Vlookup

[Johnny4strings]

Hello everyone!

I am in the process of making a dropdown-based table to fetch data. I have gone through the motions to create the dropdown via data validation, and that works fine, however I am in the process of trying to get the data I need and I will get N/A in the cell. The table I am attempting to populate INTO is supposed to give me an amount of issues by year, sorted as follows:

		A	B	C	D	E
1		TIMING	TYPO	MISC
2	OCT	N/A
3	NOV
4	DEC

<tbody>
</tbody>

I am trying to get this data to populate from a “timing” table that is structured like this:

	A	B	C
		2018	2019
1	OCT	1	1
2	NOV	2	2
3	DEC	1	3
4

<tbody>
</tbody>

The overall goal is to render a “1” in cell B1 of the bottom table with the use of a dropdown.
The data for the dropdown, the year, is on another table and tab titled “year” and is only one column, years 2018 to 2030 represented. I know I need to use a Vlookup of some kind, but I’m unsure as to how to structure it.

Thanks ….VERY much for the time, everyone.