Sorry for the blank post...

I ran into a similar problem today. I have my calculation set to automatic.
I was using the following formula: =IF(A2="C",$C$1*B2,$D$1*B2)

It gave me the correct value for the row I was in. As I clicked that cell on
the bottom right corner and dragged it down the column, it copied the formula
correctly (noting both the relative and absolute references), but the value
that appeared in each cell was the calculation from the first formula. In
other words, in the first cell, I would see 48.9671, and after copying the
formula, it showed as 48.9671 in each of the concurrent cells.

Again, I made sure that automatic calculation was enabled. I tried opening a
new workbook from the workbook I was working, copying the data and
re-entering and copying the formula - same results. Then I opened another
instance of Excel from the start menu and copied the data, re-entered the
formula and copied. This time it worked. The workbook that I was working in
was sent to me from another organization, but it was created through DTS for
either SQL Server or Oracle, or Pervasive....I know they're using a SQL
engine, just not sure which one. I was hoping somebody might have some
insight into what's going on with this specific workbook. Oh, also forgot to
mention, in our office 2007 suite, we have our default set to save in
compatibility mode for 2003 users in our outside offices.

"Jim Thomlinson" wrote:

Your calculation is probably set to manual. Tools |Options |Calculation
(Check Automatic)...

F9 will do a one time calc for you...
--
HTH...

Jim Thomlinson


"Copying VLOOKUP formulas" wrote:

That worked great...with one exception. When I click the bottom left corner
of the cell and drag it down the column, the formula copies correctly but the
returned value is incorrect. The formula copies correctly but it won't
return the correct value unless I click on the formula bar and then hit
enter. I don't have to change anything in the formula itself, just
highlighting the formula bar and then hitting ENTER corrects the returned
value. Any trick to doing that all at once?

"Gary''s Student" wrote:

replace your form with:

=VLOOKUP(K4,$A$3:$C$714,3,FALSE)

now the K4 will change, but the lookup table will not
--
Gary''s Student - gsnu200757


"Copying VLOOKUP formulas" wrote:

I have the following formula inserted into a cell. I know it works because
it returns the correct value.

=VLOOKUP(K4,A3:C714,3,FALSE)

I now need to copy this same formula in the same column over about 700 rows
of data. The "K4" will obviously change since that's the value I'm looking
for, but how do I lock the range table, i.e. "A3:C714", so it won't increase
when I copy the formulas down? Also, is there something I need to do in
Paste Special to make the formula work in the other rows? I've tried
everything and I can't get the formula to copy correctly. I obviously don't
want to retype it 700 times.

Any help would be GREATLY appreciated.