MATCHING QUESTION

[banneduser123]

Hello again guys...

I want to check column A, B, + C and see if it's each row in each of those columns is the same as a row in column E+F+G.
They must be respective.
i.e. row 2 in column a, b, + c has to be the same as a row in column e, f, +g.

thanks a lot.
rishi

 

[Aladin Akyurek]

=AND(A2=E2,B2=F2,C2=G2)+0

 

[banneduser123]

thanks but,

thanks a lot, but how can i have row a, b, c search through the entire column of e, f, g. meaning they wno't necessarily be in the same row.


thanks agian

 

[Aladin Akyurek]

Re: thanks but,

thanks a lot, but how can i have row a, b, c search through the entire column of e, f, g. meaning they wno't necessarily be in the same row.


thanks agian

=ISNUMBER(MATCH(1,IF($E$2:$E$100=A2,IF($F$2:$F$100=B2,IF($G$2:$G$100=C2,1))),0))+0

which is confirmed with control+shift+enter (not with enter) and copied down as far as there are records in A:C.

 

[banneduser123]

thanks a lot aladin!!!