Compare Two Tables and Return Values Only on Rows that Match the other Table

this vlookup would be one way...
=IFERROR(VLOOKUP($F2,$A:$D,COLUMN(B$1),FALSE),"")
dragged right and down, assumes table A values are in columns A, B, C and D, you would put it in column J and drag right then down.

You're welcome, glad I could help.
AND, Thank You for the rep!

for the reputation part there is *Add Reputation under each poster's post that you can click on and it will add reputation points.
As for returning more than one result, yes, that can be done.
You probably should post a sample spreadsheet with enough samples so we can see what you are dealing with, and your expectations of the results.
For example, are the second instances in the first table or the second table or both? is a helper column out of the question?
If a helper column is not acceptable then it may require an array formula.

under the quick reply window are three buttons, post quick reply, go advanced and cancel.
click on go advanced then in the next window part way down is another button "manage attachments", click on that and it will open another window.
at the top will be browse and, for ease of posting I find it easiest to post my sample on my desktop, but go to the file or desktop and click on it, then ok and ok or whatever the prompts say and it should be uploaded.

You might also want to remove the "solved" from this post in case others want to add their formulas too (and in the event I'm not here - cause I do have work to do that I'm paid for ).

go to the top of this thread, at the thread tools dropdown at the bottom of the list will be unmark this thread as solved.
I've got a big work project to focus on suddenly due today so I won't be able to be on for a while. Someone will help you especially if you unmark the post. Good luck.