If a name exists in a list and has a specific value next to it

Hi all,


I need help with a formula.


I am trying to write a formula which looks for whether a name (C1) exists in a list of names (A:A) AND has a 1 next to it (in column B).


Something like:


=IF(AND(name_list = name, name_value = 1), value_if_true, value_if_false)



By: msr

Leave a Reply

Your email address will not be published. Required fields are marked *