Question description:
This user has given permission to use the problem statement for this
blog.
i need help conditioning cells in a If cell A1, sheet1 contains "text-x", then cell A1, sheet2 fills cell w/ A2 sheet1's quantity.
Solved by S. Q. in 32 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
14/08/2018 - 06:07
Hi
User
14/08/2018 - 06:07
hello
User
14/08/2018 - 06:07
thanks for your help
User
14/08/2018 - 06:07
did you see my question
Excelchat Expert
14/08/2018 - 06:07
could you please explain little bit more
Excelchat Expert
14/08/2018 - 06:07
es
Excelchat Expert
14/08/2018 - 06:08
*yes
User
14/08/2018 - 06:08
i'm wondering how to format a cell to pull from a list of orders.. for example..
User
14/08/2018 - 06:09
apples 2 cases, bananas 3 cases, banana green 2 cases, oranges 1 case, juice orange 1 case
User
14/08/2018 - 06:09
in vertical format
User
14/08/2018 - 06:09
shall i show you in the preview?
Excelchat Expert
14/08/2018 - 06:10
yes, it would help
User
14/08/2018 - 06:10
so
User
14/08/2018 - 06:10
we have a "recap sheet" that we utilze to order
User
14/08/2018 - 06:10
i'll show in preview
Excelchat Expert
14/08/2018 - 06:11
sure
User
14/08/2018 - 06:12
so what i'm looking for is for the cell in sheet "recap" column B to pull from sheet "order sheet"s quantity
User
14/08/2018 - 06:12
so, for example
User
14/08/2018 - 06:12
...
User
14/08/2018 - 06:12
the quantities would automatically load the clients bananas from the first sheet
User
14/08/2018 - 06:13
makes sense?
User
14/08/2018 - 06:14
made a correction in sheet 1
User
14/08/2018 - 06:14
order sheet.. added ripe to bananas
User
14/08/2018 - 06:14
thanks
Excelchat Expert
14/08/2018 - 06:15
okay
Excelchat Expert
14/08/2018 - 06:20
Does this solve you rissue
User
14/08/2018 - 06:21
looks as tho you might have solved it batman
User
14/08/2018 - 06:21
or batlady
Excelchat Expert
14/08/2018 - 06:21
great
User
14/08/2018 - 06:21
so essentially you have the formula pulling directly from the cell
User
14/08/2018 - 06:21
so,
User
14/08/2018 - 06:22
if i need to condition the cell to read from sheet 1 with specifics now..
User
14/08/2018 - 06:22
for example
User
14/08/2018 - 06:22
apricot loose
User
14/08/2018 - 06:22
apricot organic
User
14/08/2018 - 06:22
apricot bunch
User
14/08/2018 - 06:22
how would i differentiate
User
14/08/2018 - 06:23
as in, where would i make that command sheet
User
14/08/2018 - 06:23
?.. make sense?
Excelchat Expert
14/08/2018 - 06:23
I did not follow
User
14/08/2018 - 06:24
okay.. sorry, i thought i was running out of time..
User
14/08/2018 - 06:24
okay.. essentially...
User
14/08/2018 - 06:24
i'll copy and past, one moment
Excelchat Expert
14/08/2018 - 06:24
cool
User
14/08/2018 - 06:26
okay
User
14/08/2018 - 06:27
soo, that's an example of my P.O
User
14/08/2018 - 06:27
my recap sheet, i'll have pre made myself
User
14/08/2018 - 06:27
but would read more like this.. (pasting example now)
User
14/08/2018 - 06:29
so
Excelchat Expert
14/08/2018 - 06:29
what is the question?
User
14/08/2018 - 06:29
i have to pull from sheet 3 the potatoes
User
14/08/2018 - 06:30
but the text is differnt on sheet 3 than it is on sheet 4
User
14/08/2018 - 06:30
would that be an issue?
Excelchat Expert
14/08/2018 - 06:31
would it be always the first word?
User
14/08/2018 - 06:31
likely.. then followed by a more specific description
User
14/08/2018 - 06:32
for example.. looking at the roots..there's 5 different types of roots
User
14/08/2018 - 06:32
as well as pounds/ counts..
Excelchat Expert
14/08/2018 - 06:32
if it's the first word then I will extract in column A
User
14/08/2018 - 06:33
understood.. now what about the second text.. the 40ct 50ct etc
User
14/08/2018 - 06:33
would that have to be differentiated in the conditional rules?
Excelchat Expert
14/08/2018 - 06:34
what do you mean?
User
14/08/2018 - 06:34
okay.. one moment.. sorry
User
14/08/2018 - 06:35
okay.. when you listed the conditions on order sheet
User
14/08/2018 - 06:35
i get it
User
14/08/2018 - 06:36
.. i'll just have to script a column before the descriptions in which the formula can understand
User
14/08/2018 - 06:36
okay.
User
14/08/2018 - 06:37
soo, i'll be able to copy your cells you created and work on it myself?
Excelchat Expert
14/08/2018 - 06:37
yes
User
14/08/2018 - 06:39
okay, great.. thanks for your help!!!
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.