Ranged Formula

[Adrac]

Hello All,

I have a formula that looks at a column and gives a yes no result but I would like it to look at several columns to find the information:

Currently looks at E:E but would like it to look at E:M and only row 2

=IF(AND(C$1='Raw Data'!$E:$E,$A2='Raw Data'!$A:$A),"YES","NO")

Thank you in advance.

 

[Aladin Akyurek]

have a look at COUNTIFS.

 

[Adrac]

I have looked into this before but couldn't find the right combination. Can you help me complete a formula?

 

[Aladin Akyurek]

I have looked into this before but couldn't find the right combination. Can you help me complete a formula?

Does this work for you?

=IF(COUNTIFS('Raw Data'!$A:$A,$A2,'Raw Data'!$E:$M,C$1),"YES","NO")

 

[Adrac]

Does this work for you?

=IF(COUNTIFS('Raw Data'!$A:$A,$A2,'Raw Data'!$E:$M,C$1),"YES","NO")

this just displays #VALUE

 

[Aladin Akyurek]

this just displays #VALUE

Control+shift+enter, not just enter:

=IF(SUM(IF('Raw Data'!$A$2:$A$10=$A2,IF('Raw Data'!$E$2:$M$10=C$1,1))),"YES","NO")

 

[Adrac]

Control+shift+enter, not just enter:

=IF(SUM(IF('Raw Data'!$A$2:$A$10=$A2,IF('Raw Data'!$E$2:$M$10=C$1,1))),"YES","NO")

yay! that worked thank you so much.

 

[Aladin Akyurek]

yay! that worked thank you so much.

You are welcome.