|
IF/OR Statement
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 |
IF/OR Statement
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 |
IF/OR Statement
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 |
IF/OR Statement
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 |
IF/OR Statement
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 "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 |
| All times are GMT +1. The time now is 10:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com