VLOOKUP Problem, Please Help!

S

Susan

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!
 
T

T. Valko

Make sure calculation is set to automatic.

Tools>Options>Calculation tab>Automatic>OK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLOOKUP Problem when information is changed 2
VLookup only calling one cell 3
VLOOKUP returning #N/A ?? 3
Need Help with VLOOKUP 4
vlookup 14
VLookup or Macro? 0
VLOOKUP isn't working properly in Excel on Mac 1
Vlookup with an Arrayformula.... HELP! 0

Top