Excel Formula for matching 2 columns values

[fchachar]

I have a Workbook with lots of Data in each row, I want to match Cells from:

'any value of Column1 = any value of Column2' & 'any value of Column3 = any value of Column4'

then show results anywhere at the bottom. If the condition is True then show the whole ROW instead of single cell or the value, if the results dont match ignore.


Thanks in advance.