I have this very long formula and need to simplify it
=IF(Type="P",VLOOKUP(Player,Fees_Table,2,FALSE),IF (Type="A",VLOOKUP(A_Person,Fees_Table,2,FALSE),IF( Type="M",VLOOKUP(Player,Fees_Table,2,FALSE))))
If anyone could help I would be on happy girl thanks