2 sets of data. Need to compare the values of matching lines

Good morning

In a nutshell I have 2 sets of data on the same worksheet.

Set1
Column A is Invoice reference, Column B is Invoice value.

Set 2

Column D is Invoice reference, Column E is invoice value.

What I need to do (assuming its possible) is to determine that A, the invoice reference exists in both sets of data, and B if it does, are the values the same, and if not what is the difference?

Any suggestions would be greatly appreciated,

Thanks in advance

Look at VLOOKUP function

try ..

=IFERROR(IF(VLOOKUP($A2,$D$2:$E$1000,2)=$B2,"Amount Matched","Amount not matched"),"No matched invoice")

Hi John,

That formula is great. it appears to work yet not for all of the data.

I have attached the worksheet.

Thanks in advance

... so what are the "errors"?

cell A26 is a match for D2 for example yet this formula says otherwise

In your file for A26 , F26 says "Amount Matched" ??????

My apologies. I was looking at this completely the wrong way. Thank you so much

No problem ... I often look at things the wrong way!!!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

perfect. thanks again