comparative

[snasui]

Please attach the updated file and point to cell that shown incorrect result and fill in the correct value for that cell for easy to understand it.

[sna]

Thanks for your kind ,I just highlighted the non matching value

[snasui]

Adjust your formulas as below:

Q13
=IFERROR(INDEX('T24 INTRA'!N:N,MATCH(E13,'T24 INTRA'!$G:$G,0))+0,"")
Enter > Copy down

Please update column Q with my formula on above.

For the latest file in post #22, could you please explain how do you know the value in I23 and T23 is the same?

What the condition for convert the value in I13 (or T23)?

For now I think the formula in cell AB13 is:

=AND(F13=Q13,G13=R13,H13=S13,OR(I13=T13,I13*100=T13),J13=U13,ISNUMBER(SEARCH(V13*IF(R13="USD",4000,1),K13)),L13=W13,LEFT(M13,10)=LEFT(X13,10))

[sna]

Hi Dear thank you but I have currency KHR,USD,THB
1USD=4000KHR,1THB=129.55 KHR

[snasui]

You can adjust this part:

...V13*IF(R13="USD",4000,1)...

please try with yourself first.

[sna]

Ok thank you

[sna]

I check it error date and rate base on my formula in intranet column AH and AJ.
What's wrong with the formula?

[snasui]

Please point to the error, provide the correct result, all condition you use and attach file again.

[sna]

Here is attached file I check in sheet Reconcile Txn

[snasui]

Please read my post (#28) carefully.

[sna]

I put the test result in ReconcileTxn in column A

[snasui]

You can add +0 for convert date as text to date as number in old formula in column 'E' as below:

=IFERROR(INDEX(INTRANET!AH:AH,MATCH(ROW()-12,INTRANET!$AG:$AG,0))+0,"")

Enter > Copy down.

[sna]

Thank you

[sna]

No luck ,see attached file

[snasui]

Please check regional and language on your machine, the format of date must be dd/mm/yyyy not mm/dd/yyyy.

Or change the formula on C13 with this,

=IFERROR(TEXT(INDEX(INTRANET!AH:AH,MATCH(ROW()-12,INTRANET!$AG:$AG,0)),"m/d/yy")+0,"")

Enter > Copy down.

[sna]

Thank you