Change data based on specific column?

I have a sheet where I have data specific to each day in a separate column.

Please Login or Register  to view this content.

I want to have another section on the same sheet that breaks down data specific to a day.

Please Login or Register  to view this content.

Is there a way where I can have a single cell change whether Day 1 or Day 2 is broken down in my "breakdown section"?

Originally Posted by deesh123

I have a sheet where I have data specific to each day in a separate column.

Please Login or Register  to view this content.

I want to have another section on the same sheet that breaks down data specific to a day.

Please Login or Register  to view this content.

Is there a way where I can have a single cell change whether Day 1 or Day 2 is broken down in my "breakdown section"?

There used to be, in very junior schools, a subject known as 'Reading and Comprehension' whereby a child could read the letters D O and G as d-o-g = dog and associate that with some furry little ball on 4 legs that runs, barks, bites, and pee's on the lawn.

I guess I must have failed that subject.

I cannot see two occurances of 'A' to relate to [A*2] [A*3] etc (nor to any other letter/day combination).

Is there some guide as to the criteria for inclusion on the second section?

---

I'm sorry I wasn't clear - this requires a simple solution to a complex concept.

I will have to be more specific. This excel sheet is for a 12 day weight lifting program.

I have 12 columns representing each day of lifting. Each row represents an exercise.

Here is an example:

Please Login or Register  to view this content.

Above, each exercise has a weight assigned to it for each day. This is where it gets tricky. The number above denotes the weight I will do for my set of 6 repetitions. Before I do that set of 6 repetitions, I warm-up with a set of 12 repetitions(at 50% of the weight assigned to 6 repetitions) a set of 10 (at 75% of the weight assigned to 6 repetitions) set of 8 at (85%of the weight assigned to 6 repetitions).

On the same excel sheet I have a section that I will select and print out each day to use as reference while at the gym. I would like this section to call on a certain day and break down each exercise as I've explained above

Here is an example:

Please Login or Register  to view this content.

I can't figure out a way for an excel sheet to call on a specific column, or in my case a specific day, and then apply multiplication to it.

Please let me know if I am still not clear? I am willing to E-mail my sheet if need be.

Originally Posted by deesh123

I'm sorry I wasn't clear - this requires a simple solution to a complex concept.

I will have to be more specific. This excel sheet is for a 12 day weight lifting program.

I have 12 columns representing each day of lifting. Each row represents an exercise.

Here is an example:

Please Login or Register  to view this content.

Above, each exercise has a weight assigned to it for each day. This is where it gets tricky. The number above denotes the weight I will do for my set of 6 repetitions. Before I do that set of 6 repetitions, I warm-up with a set of 12 repetitions(at 50% of the weight assigned to 6 repetitions) a set of 10 (at 75% of the weight assigned to 6 repetitions) set of 8 at (85%of the weight assigned to 6 repetitions).

On the same excel sheet I have a section that I will select and print out each day to use as reference while at the gym. I would like this section to call on a certain day and break down each exercise as I've explained above

Here is an example:

Please Login or Register  to view this content.

I can't figure out a way for an excel sheet to call on a specific column, or in my case a specific day, and then apply multiplication to it.

Please let me know if I am still not clear? I am willing to E-mail my sheet if need be.

To apply multiplacation to a cell, put the multiplier in a spare cell and Copy it,

Select the concerned cells, and

Paste, Special - set to Multiply

Is this what you mean?

---

Ah, we are getting much closer to the answer!

I forgot one detail. See the following example:

Please Login or Register  to view this content.

How can I have a cell where all I need to change is X, which represents one day (or in excell's case one column of data), and have the rest of this chart get broken down as shown above. Remember that θ, t, and α change depending on the day.

Originally Posted by deesh123

Ah, we are getting much closer to the answer!

I forgot one detail. See the following example:

Please Login or Register  to view this content.

How can I have a cell where all I need to change is X, which represents one day (or in excell's case one column of data), and have the rest of this chart get broken down as shown above. Remember that θ, t, and α change depending on the day.

Assuming your 'day' is in row 6, then try

="θ = Bench press weight on "&A6&" "&B6
etc

Originally Posted by Bryan Hessey

Assuming your 'day' is in row 6, then try

="θ = Bench press weight on "&A6&" "&B6
etc

Your suggestion only pulls data from one cell; however, I need the sheet to be more dynamic since I have so much data.

I've thought about this long and hard and realized a simpler way to ask my question. Disregard my previous postings and see the following example:

Please Login or Register  to view this content.

I want my sheet to function so that when I replace "X" by typing a "1" then "t" and "s" are replaced by their values 100 and 200 for Day 1. Similarly, I when I replace "X" by typing a "2" I want "t" and "s" to be replaced by their values 110 and 210.

Is this possible in excel?

Originally Posted by deesh123

Your suggestion only pulls data from one cell; however, I need the sheet to be more dynamic since I have so much data.

Correctly entered it adds data from cells A6 and B6, both addresses of which were guesses as your examples give no indication as to which cells data is in.

I've thought about this long and hard and realized a simpler way to ask my question. Disregard my previous postings and see the following example:

Please Login or Register  to view this content.

I want my sheet to function so that when I replace "X" by typing a "1" then "t" and "s" are replaced by their values 100 and 200 for Day 1. Similarly, I when I replace "X" by typing a "2" I want "t" and "s" to be replaced by their values 110 and 210.

Is this possible in excel?

Many things are possible, and to be able to detect an entry in another cell and use that or some indicated data in a formula is reasonably standard practice.

However, without using VB code a cell will contain only the result of it's own formula.

For the cell containing t to react to you enterering a figure in a cell the formula must be aware of that cell, ie

=If(A1="x","",If(A1=2,200,100))

should fill your request.
---

For the cell containing t to react to you enterering a figure in a cell the formula must be aware of that cell, ie

=If(A1="x","",If(A1=2,200,100))
---

This method works, but excel will not allow me to put 12 arguments like this:

Please Login or Register  to view this content.

"You've entered too many arguments for this function."

Originally Posted by deesh123

This method works, but excel will not allow me to put 12 arguments like this:

Please Login or Register  to view this content.

"You've entered too many arguments for this function."

For that you will need a lookup table, see VLookup in Help
---

I've been trying to implement a VLOOKUP table on my sheet, but I don't get the hang of them.

What would my "=VLOOKUP..." statement look like for the following simple example? Remember, I want variables t and s to indicate data from Day 1 or Day 2 when variable X is changed to a 1 or a 2.

Please Login or Register  to view this content.