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)

 

Thanks!!

By: msr

Leave a Reply

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