You can get the price in Col D of Sheet1 by this formula in D2
=VLOOKUP(A2,Sheet2!A:D,4,False)
and copying down

"Steve" wrote:

Sheet 1 Column A = Product n, Column D is the IF Statement
Sheet 2 Column A = Product names, Column D = Price

I just realized that the system doesnt allow there to be any large spaces
between words. Weird.

Steve


"Sheeloo" wrote:

Which column on Sheet2 has the price? I presume Col is product.


"Steve" wrote:

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