I've got two worksheets with values in columns A through E in both. Each column is a different criteria (i.e. column A = Name, B = Color, etc..). What I'm trying to do is create a formula to put in column F of one of the sheets that will look for an exact match of all 5 columns that are in the same row. If it finds a match it will display nothing but if it doesn't find a match it will then display an X. So for example, if in row 25 of worksheet A it had values of:

Column A = John, Column B = Red, Column C = 3, Column D = 1, Column E = 07F

If there is an exact match in any row of worksheet B then the formula will display nothing. If there is no exact match in any row of worksheet B then the formula would display an X in the cell. Thanks in advance for any help.