Need help with Budget Files Formulas and Linkage not working

you really should have a field for type of membership rather than using color

color does not lend itself to be manipulated easily
even in your sheet you had two different shades of blue so it didnt match up properly

here is the solution with member type in an actual column