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...