Help with formula matching 2 columns verse 2 other columns

[zone709]

Hi trying to have a certain kind of formula in column E so it can tell me if its a match or not. A & B would have to match C & D or not. Just the ID and amount verse each other.
I can do the formula to match one column verse the other but having a hard time on two columns matches thanks.

Book1
	A	B	C	D	E
1	ID	Amount	ID	Amount	Forumla Needed
2	4	$ 25.00	4	25	Match
3	5	$ 50.00	5	55	No Match
4	7	$ 75.00	7	70	No Match
Sheet1

 

[Cubist]

I've changed the formula to go off of C. It's a dynamic array so you shouldn't have to drag down. Make sure you grab all the ranges. If your data last row is 10 it should be A2:A10... same for the other ranges.

Book1
	A	B	C	D	E
1	ID	AMOUNT	ID	AMOUNT	Formula
2	4	25	8	21	match
3	5	23	4	20	no match
4	7	12	10	21	no match
5	8	21	7	12	match
6	10	22	5	23	match
Sheet8

Cell Formulas
Range	Formula
E2:E6	E2	=LET(b,BYROW(C2:C6,LAMBDA(r,XLOOKUP(r,A2:A6,B2:B6,,0)))=D2:D6,IF(ISERROR(b),"not found",IF(b,"match","no match")))
Dynamic array formulas.

 

[zone709]

k thanks. i put formula in and runs perfect ty.