IF Statement with multiple return

Hello, I am working with a data sheet that needs to have items matched and paste data from one sheet to another. In order to do so for thousands of inputs, I'm trying to use the IF Statement. If the...