I need a simple statement to answer the following:
Sheet 1 will have the If Statement
Sheet 2 will have the data needed to answer the IF statement

Sheet 1
Column A Column B Column C Column D
Row 1 Product n If statement
Row 2 Product n If statement
Row 3 Product n If statement
Row 4 Product n If statement
Row 5 Product n If statement

Sheet 2

Column A Column B Column C Column D

(Price)
Row 1 Product 1 If statement
Row 2 Product 2 If statement
Row 3 Product 3 If statement

I need the IF statement to be able to be able to distinguish the product
name and place the appropriate price.

I tried VLOOKUP but i wasnt successful at it.

Thank you for the help.

Steve