Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
If statement or lookup statement not sure | Excel Worksheet Functions | |||
Sum if statement with a left statement | Excel Discussion (Misc queries) | |||
SUMIF statement with AND statement | Excel Discussion (Misc queries) | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions |