I have 2 workbooks and i want to check if a row matches another row in another book.

Lets say in Workbook1 you have the following

Workbook 1 | Workbook2 | |||||||

A | B | C | D | T | Y | U | O | |

W | E | R | T | |||||

A | B | C | D |

I have the following formula but its not working

{=AND(EXACT(A2:D2,[Workbook1.xlsx]Workbook2!$A$2:$D$4))}

Gives me a result of false

Just want to know if that exact row is within the array.

Can anyone help please