=IFS error when adding second argument

[zombiehairdu]

=IFS(HLOOKUP(P1, B1:V2, 2, 0)="TM", "TM - Total Managed",(HLOOKUP(P1, B1:V2, 2, 0)="BR", "BR - Broker" )

Can anyone tell me why this doesn't work? If I remove the 2nd argument it works fine, however when I want to test for other values it gives me the, "Not trying to type a formula?" error.

[AliGW]

Could it be incorrect parenthesis (before the second HLOOKUP)? Try this:

=IFS(HLOOKUP(P1, B1:V2, 2, 0)="TM", "TM - Total Managed",HLOOKUP(P1, B1:V2, 2, 0)="BR", "BR - Broker" )

[zombiehairdu]

...

Well I feel stupid, that is exactly what was wrong.

Thank you.

[AliGW]

No need - we've all been there, done that AND got the T-shirt!!!