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
Check out the Formula Handbook template!