Comparing a Cell to a column

Hey!

I am looking to do this trickery with excel, but I have hit a wall!

I have 5 column

Column two has multiple cells with the same number as column one (they are on different sheets)

I want to find any match for the first cell (A2 in this case) in the 2nd column. Than, if they match, I want to compare the 3rd column to a another cell. If they match again, I want to copy the cell from column 4 into column 5

My first attempt was to use =If(And(...)) but it will only check for the same row. (If row 6 match row 2, it won't show up, but if it match row it workd perfectly)

Anyone knows a way to work this out?

Thanks!

Edit:
Attached Exemple! Thanks for below
I've put color to help figure out where the number come from!

exemple.xlsx

You get better help on your question if you add a small excel file, without confidential information.

Please also add manualy the expected result in your file.

To Attach a File:

1. Scroll down to the window below your post Additional Options
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.