Help with a function extracting a word from another sheet

[check00]

I need some help with a function I am not 100% sure what to use even.
I've attached a worksheet. It doesnt look like it would be complicated.

Basically, I need excel to search for A3's name "3i Group PLC" in the sheet "country of origin" (which is in the 2nd column), and copy its origin into F3. I need to be able to drag it down because there are over 1000 firms AND if there is no firm (like A5) I'd like it to leave a blank space in f5


I would really appreciate your help!
Thanks in advance !

[zbor]

Here, try this:

Please Login or Register  to view this content.

[Fotis1991]

Hi

Try in F3 and copy down.

=IFERROR(INDEX('country of origin'!$B$2:$B$100,MATCH(A3,'country of origin'!$A$2:$A$1000,0)),"")

[check00]

Thank you so muuuch ! They both worked!!