Matching lists of keywords

Hi i have two lists of keywords

So keyword list 1:
dog
cat
mouse
monkey
rabbit

Keyword list 2:
cat
monkey
rabbit
elephant

I want to match the keywords (from keyword list 2) with the exact keywords from keyword list 1 for every row, so it would look like:

Keyword list 1 Keyword list 2
cat cat
monkey monkey

I can't sort them by alphabetical order since some keywords are not in both columns e.g. elephant

Another important thing
Keyword list 1 and keyword list 2 have different data attached

For example
Keyword list 1 has the following columns - keywords, competition score, unique score
While
Keyword list 2 has - keywords, keyword volume, cpc

How can i automatically do this, without needing to it manually (i have a very large list of keywords)


Regards,
Chris

Try something on these lines

=IFERROR(INDEX(List2,MATCH(A1,List2,0)),"")

Adjust ranges accordingly

hi Chris. assuming Keyword list 1 is in A1:A5 & Keyword list 2 is in E1:E4, try:
=IF(ISNA(VLOOKUP(A1,$E$1:$E$4,1,0)),"",VLOOKUP(A1,$E$1:$E$4,1,0))

Do you want the non-match items removed from both lists??