If cell equals with a value in another cell then cellX

i am trying to use IF in the following arguement:

I have a sheet with a list of products next to it a list with manufacturer. In each product corresponds to a certain manufacturer of the list.

Now how i can tell a cell that if it found in the cell A1 on another sheet the a value from the list of products in the previous sheet to give me as a result the corresponded manufacturer.

I tried the following as a test:

=IF(COUNTIF(B9;data!A:A);data!B:B;"product not found")

were B9 is the cell that i put the product manually, data!A:A is the range of the sheet that i have the list of the products and data!B:B is the list with the manufucturers.

The syntax i guess is ok since its working properly in excel but the thing is that i get always (product not found).

Could please someone help me? Thanks in advance!