IF/OR Statement

[Steve]

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

 

[Sheeloo]

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

 

[Steve]

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]

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

 

[Francis]

one other way

=LOOKUP(A2,Sheet2!$A$2:$A$4,Sheet2!$D$2:$D$4)
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another