Matching and Comparing two tables

Hello Everyone!!
I can't understand why I can't accomplish what I'm trying achieve for my problem or why this is difficult lol.. , but I just can't seem to find the answer to what I'm looking for. Here's my issue.
I have a worksheet with multiple columns and two tables on one sheet. I simply want to compare two separate columns within it to see if they match.
If they do match, I want the next blank column to display the common matched value. All the matching values would be in text format.

Example: If the text data in Column D (of table1) matches the text data in Column K (table 2), it would return the text from Column D (table 1) into the next blank Column ("L" of table2).

I hope I was able to explain my issue without being too confusing.

Any Help would be GRREEAATTLLY Appreciated!!

Thanks for the reply! I tried your suggestion and unfortunately it didn't pull what I'm looking for, However; it did make my wheels turn a bit.
I attempted to try =if(D3:d3920=K3:k2135,D2,"")
It did not return any good results, but maybe the formula I just attempted might of explained a little bit more of what I'm trying to accomplish.
The data in D and K are serial #'s, so they all have unique values and no duplicate in those columns.

OK. I think I have a better way of explaining my issue.

I have two tables of data that are on the same spreadsheet. Table 1 has the "master inventory list" and table 2 has the "order" list. The main items I want to compare are the Serial numbers (which are in Column K of table 2 and Column D of table 1.) In Column "A" of table 1, I have the Equipment Parts that correspond to the serial number in Column D.

Now the tricky part: In Table 2, there is a blank Column "L" where I would like to have my common result placed. The common result of the matching serial numbers would be the "Equipment Part" that is listed in Column A of table 1. If the two serial numbers match (Column K and Column D), I would want the Equipment Part referenced from the master list Column A would be displayed over to Column L of table 2.

Hi dude,

cn u plz share d sheet.

Regards
Ritesh

i wasn't able to uploade the fileexample file for seom reason so I pasted some of the exmaple informtaion below. Columns A-E is Table1 and H-L is Table2. Thanks



A B C D E F H I J K L

Till X C 546 Till X 87
Brake X C 213 Brake X 559
Brake X C 54968 Brake X 87
Brake X C 213 Brake X 213
Brake X C 54 Brake X 54
Brake X C 5132 Brake X 754
Brake X C 5665 Brake X 231
Brake X C 231 Brake X 23
Brake X C 787 Brake X 465
Brake X C 754 Brake X 5646
Brake X C 231 Brake X 21213
wheel X C 23 wheel X 754
Brake X C 465 Brake X 231
Brake X C 5646 Brake X 23
Brake X C 21213 Brake X 465
Brake X C 687 Brake X 5646
Brake X C 213 Brake X 21213
Brake X C 321 Brake X 321
Tire X C 999 Tire X 999
Brake X C 884 Brake X 54
Brake X C 87 Brake X 5132
Brake X C 89 Brake X 5665
Horn X C 87 Horn X 87
Brake X C 89 Brake X 787
Brake X C 8 Brake X 546
Brake X C 87 Brake X 213
Brake X C 559 Brake X 54968
Brake X C 87 Brake X 213

Unfortunetly that did not paste the way I wanted or how it looked when I initally posted the above information. Column A has the "part", B "X", C "C", D "Serial Number" E "blank", F&G Blank H (start of table 2) Part, I "X", J Blank, K Serial Number, L is blank