Simplify excel formula

L

Lulu

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
 
B

Biff

Hi!
very long formula
Click to expand...

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
 
A

Aladin Akyurek

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