Snasui Excel Forum

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.

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

snasui wrote: Sat Sep 26, 2020 7:37 am 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))

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

You can adjust this part:

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

please try with yourself first.

Ok thank you

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

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

Here is attached file I check in sheet Reconcile Txn

Please read my post (#28) carefully.

I put the test result in ReconcileTxn in column A

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.

Thank you

No luck ,see attached file

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.

Thank you