why isn't this formula working?
=IF(LEFT('MORS email'!$N$2,2)="XS", VLOOKUP('MORS email'!$O$2,'Broker and Clearer IDs'!$A:$C,3,)), =IF(LEFT('MORS email'!$N$2,2)="XS", VLOOKUP('MORS email'!$O$2,'Broker and Clearer IDs'!$A:$C,3,))
Solved by O. H. in 28 mins