Hi. I am working with essentially the data below:

A B C D E

21 - #1 2008 2012 2016 2020
22 - #2 2009 2013 2017 2021
23 - #3 2010 2014 2018 2022
24 - #4 2011 2015 2019 2023


I am trying to get a formula that will search for the year in A5 in the above array and return a result of the # in column A corresponding to the row of the year.

HLOOKUP(A5,A21:E24,1,FALSE) is what I've been trying, but I get an N/A response. Am I confusing the H and V LOOKUP functions? Or do have the wrong function altogether?

Thanks!!