Excel INDEX MATCH COUNTIF Support

I have a table and a field I am trying to pull data from the table to make the table dynamic. I have an INDEX MATCH COUNTIF statement that is working for every tier except the first and I have to change the reference cell there, but this prevents the formula from working on all the other cells. I just need help solving this one issue. I'd like to find a go to person for stumbling block issues one in a while.