I have 2 tabs within my spreadsheet. Tab1 has the following columns:
Date......Code#....RunTime....Factor....Total
3/1/08...12...........1.45..........(blank)...(calcula ted)
3/1/08...10...........2.60..........(blank)...(calcula ted)
3/2/08...15...........3.68..........(blank)...(calcula ted)

The "Total" column will calculate once the "Factor" is known. The "Factor"
must be automatically selected from a table on Tab 2, depending on the value
which is input into the "Code#" column on Tab 1, above.

Tab 2 looks like this:
Code#.....Factor
10...........66
12...........86
15...........29

The "Factor" in the table on Tab 2 is calculated on a third tab, so the
factors will change periodically.

1. How do I set up an equation in the "Factor" column of Tab 1, so that a
value will be automatically chosen from the "Factor" column of Tab 2 based on
what the user inputs into the "Code#" column in Tab 1 (in other words, the
value input into the "Code#" column in Tab 1 will be compared to the table in
Tab 2, and the corresponding "Factor" from that Table in Tab 2 will be input
into the "Factor" column in Tab 1.

2. When the data in a third tab is changed, the "Factor" values in the table
in Tab 2 will automatically change. BUT....I do not want the values (either
the "Factor" shown in Tab 1 OR the calculated "Total" in Tab 1, to change for
all data entered up until that point. Only the new entries after the data
change should show new "Factors" and resulting "Total" calculations.

If anyone can help me with this, I would be thrilled.
Thanks so much in advance.
SC

Assuming that tab2 occupies A1:B4 of sheet2, here is a formula for the FACTOR
column of tab1:

=VLOOKUP(B2,Sheet2!$A$1:$B$4,2,FALSE)

That should do for question 1. As for question 2, I am not sure how to do
this, but try turning off auto table recalc:

Tools-Options-Calculation-Manual radio button (uncheck recalc before save)
--
Anne Murray


"SC" wrote:

I have 2 tabs within my spreadsheet. Tab1 has the following columns:
Date......Code#....RunTime....Factor....Total
3/1/08...12...........1.45..........(blank)...(calcula ted)
3/1/08...10...........2.60..........(blank)...(calcula ted)
3/2/08...15...........3.68..........(blank)...(calcula ted)

The "Total" column will calculate once the "Factor" is known. The "Factor"
must be automatically selected from a table on Tab 2, depending on the value
which is input into the "Code#" column on Tab 1, above.

Tab 2 looks like this:
Code#.....Factor
10...........66
12...........86
15...........29

The "Factor" in the table on Tab 2 is calculated on a third tab, so the
factors will change periodically.

1. How do I set up an equation in the "Factor" column of Tab 1, so that a
value will be automatically chosen from the "Factor" column of Tab 2 based on
what the user inputs into the "Code#" column in Tab 1 (in other words, the
value input into the "Code#" column in Tab 1 will be compared to the table in
Tab 2, and the corresponding "Factor" from that Table in Tab 2 will be input
into the "Factor" column in Tab 1.

2. When the data in a third tab is changed, the "Factor" values in the table
in Tab 2 will automatically change. BUT....I do not want the values (either
the "Factor" shown in Tab 1 OR the calculated "Total" in Tab 1, to change for
all data entered up until that point. Only the new entries after the data
change should show new "Factors" and resulting "Total" calculations.

If anyone can help me with this, I would be thrilled.
Thanks so much in advance.
SC