How can I find all rows where a value exists and put the rows into a new table?

[statiCat]

If I have two tables, table A (1st table) and Table B (2nd table), and I want to find rows where the ID columns match but either the currency or amount don’t match….how would I do this?I can find where the IDs exist in both tables (col J) by:
=IF(ISNA(INDEX($A:$A,MATCH($F:<wbr>$F,$A:$A,0)))=FALSE,$F:$F,"")
Then if J is not "":
=IF($J:$J<>"",1,0)
So J tells me there is a match but I need to replace 1 somehow to say: if value exists in both, find all rows where it exists and put it into a new table. I would also need to be able to tell if the row came from table A or table B. Any Ideas?

 

[FDibbins]

=IF(ISNA(INDEX($A:$A,MATCH($F:$F,$A:$A,0)))=FALSE,$F:$F,"")

that may not be working quite as you expect it to. The 1st argument in MATCH needs to be a single cell (or typed in entry), not a range.

You probably need something like INDEX/SMALL/IF array function

 

[statiCat]

Thanks, I found an index/if/small function like you said that works.