Simplify excel formula
 

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

Hi!

very long formula

LOL! <g

You can eliminate the last lookup since it uses the same arguments as the
first lookup:

=IF(OR(Type={"P","M"}),VLOOKUP(Player,Fees_Table,2 ,FALSE),IF(Type="A",VLOOKUP(A_Person,Fees_Table,2, FALSE)))

Biff

"Lulu" wrote in message
...
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

=IF(ISNUMBER(MATCH(Type,{"P","A","M"},0)),VLOOKUP( LookupValue,Fees_Table,2,0),"Type
Inappropriate")

Lulu wrote:
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