VLOOKUP Problem, Please Help!
 

I have a worksheet with 170 columns and another with a vlookup formula. when
i first created the vlookup the formula worked fine, but when i change one of
the numbers in the 170 columns, the number does not change on the other
spreadsheet.

I have changed the format and they are formatted the same, i have tried
general and number as well.

Anyone have any ideas why the VLOOKUP is not updated? Please help!

VLOOKUP Problem, Please Help!
 

Make sure calculation is set to automatic.

ToolsOptionsCalculation tabAutomaticOK

--
Biff
Microsoft Excel MVP


"Susan" wrote in message
...
I have a worksheet with 170 columns and another with a vlookup formula.
when
i first created the vlookup the formula worked fine, but when i change one
of
the numbers in the 170 columns, the number does not change on the other
spreadsheet.

I have changed the format and they are formatted the same, i have tried
general and number as well.

Anyone have any ideas why the VLOOKUP is not updated? Please help!

VLOOKUP Problem, Please Help!
 

Check

Tools | Options | Calculation tab | Automatic


"Susan" wrote in message
...
I have a worksheet with 170 columns and another with a vlookup formula.
when
i first created the vlookup the formula worked fine, but when i change one
of
the numbers in the 170 columns, the number does not change on the other
spreadsheet.

I have changed the format and they are formatted the same, i have tried
general and number as well.

Anyone have any ideas why the VLOOKUP is not updated? Please help!