Index/Match IF certain year


I am trying to populate a separate sheet with the Projected Fees by year. For example, I would like to populate a 2020 column with the Projected Fees from 2020, matched to the appropriate Client. I have tried different versions of INDEX/MATCH but not working. I would like to INDEX the Projected Fee and the Year (2020) to get Client A, $30,000 and Client D, $10,000.

I have attached a sample grid below. Thanks in advance.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!