Matching two columns

[MyExcel]

Hi all
how i can match the value in column "A" with value in column "B"
but the value in column "B" not sorting
and i can't sort it

 

[MyExcel]

thanx VOG
that is what i want
really thanks

 

[Peter_SSs]

MyExcel

If that is the layout you wanted, all I was asking was for you to list column C down like that.

thanx VOG
that is what i want
really thanks

I think you might need a little more than that. What if you have more than one invoice for the same amount? In the sample below, does it mean that all three 454 invoices become 'paid' because of one payment of 454?

Excel Workbook
	A	B	C
1	Invoice	Payment	Paid?
2	454	125	Paid
3	124	454	Not paid
4	3500	986	Paid
5	454	786	Paid
6	786	701.25	Paid
7	454	3500	Paid
Invoice Paid

 

[Peter_SSs]

I guess I should offer an alternative given my scenario above. The data here is changed some more, but see if this helps.

Excel Workbook
	A	B	C
1	Invoice	Payment	Paid?
2	454	125	Paid
3	124	454	Not Paid
4	3500	454	Paid
5	454	786	Paid
6	786	701.25	Paid
7	454	3500	Not Paid
Invoice Paid (2)