Excel formula help

[sarahe33]

I need a formula that if the current year matches a certain cell I need it to show that year in the cell. I will need it to either show 1 of 7 different cells or show "N/A" 

[#2]

@sarahe33 

I'm afraid your question is too vague, you don't provide enough information for us to help you.

Please attach a relevant screenshot or a sample workbook, with a detailed description.

[#3]

In the "Year Gift Selected" column I need it to appear if its their 1, 5,10, 15, 20, or 25 year anniversary according to what year it currently is. So for instance 2021 Judy Smith has her10 year, so I would like "10 Year" to show up in column N, but if it isn't an individuals anniversary year I want the column to say "N/A" (if possible)  @Hans Vogelaar 

[#4 · Accepted solution]

@sarahe33 

Thank you!

In N2:

=INDEX($G$1:$M$1,MATCH(YEAR(TODAY()),G2:M2,0))

or

=IFERROR(INDEX($G$1:$M$1,MATCH(YEAR(TODAY()),G2:M2,0)),"N/A")

[#5]

Thank you!