If or n and formula

[Veeru106]

HI,


I am looking for a formula which fulfil my creteria.


Like it should return me “CFO”, if my table contains process as Fin,Adm,Main,HR but for main we should also consider Name”JUI”.


Which means I can use if and or formula for Fin,Adm and HR but how to include “And” formula to include both Main and JUI.


This should be one formula only


Sample file attached


Thanks a ton

 

[AliGW]

Not clear, sorry. What is CFO and how many other possible outcomes and criteria combinations could there be?

 

[Veeru106]

Hi AliGW,


CFO is just a naming convention, doesn’t mean anything.


Sorry for the confusion….i am attaching new sheet with 2 scenarios .


Please look at them.


Thanks

 

[GraH - Guido]

Concatenate Name and Process (with a separator), then make a lookup table containing concatenated label with result CFO/else... and use a simple (V)lookup.

 

[Veeru106]

Thanks GraH....it works