INDEX/MATCH formula help

[Alma]

I have attached a sample of data, it may be easier to understand what I am trying to accomplish.

Need to match the trace# on two different tabs and see if the $ amounts match.

I would like to add a formula in column S on sheet 1 and look up the Trace# from column P
and go to Sheet 2 to find the same trace # and compare the $ amounts.

If the amount matches show "Amount Matched" , otherwise "Not Matched"

VLOOKUP did not work since the amount on sheet 2 is to the left of the trace number.

In the example attached the formula should show Not Matched since the same trace number does not have the same amount

[AliGW]

There is only a sheet 3 in the attachment.

[Alma]

sorry, here is the correct one with two sheets

[AliGW]

I think this is what you are after. In S4:

=IF(INDEX('Sheet 2'!$C$3:$C$20,MATCH('Sheet 1'!P4,'Sheet 2'!$D$3:$D$20,0))=I4,"Amount Matched","Not Matched")

You can adjust the lengths of the arrays to suit your entire data set.

[Alma]

The formula works perfectly!!!

Thank you so much!

[AliGW]

You're welcome!