Writing an IF-statement for text from one column into another based on a third column of text (no numbers)

I have a few columns of data across 2 tabs. Tab 1) Scientific name and a place for Common name Tab 2) Scientific names and Common names of all of birds of the world

I want to make an IF statment that says IF text from tab 1 in the "Scientific name" column matches the text in Tab 2's Scientific name column THEN insert the Common name from Tab 2's "common name" column into Tab 1's empty column for Common name.

Do not use this terrible attempt at an IF function.
=IF(SEARCH(E5,'[Full_names.xlsx]9.1'!$B:$B),'[Full_names.xlsx]9.1'!$A:$A,0) *there won't be a case where the answer has a FALSE return, so I have false listed to return 0.

A helpful person showed me this question is answered best with the VLOOKUP function, not an IF statment.