Lookup is not auto updating info.

[wwgmr]

Hi, Im using windows 2k. I have excel formula that says
=LOOKUP(LOOKUP(I16,Abrv,Tables1!$AI$2:$AI$7),$A$8:$A$13,$D$8:$D$13)
it will find the cell once. If I change the main data it will not update though. I have even tried to change to straight lookup. They just will not update when I change the data in the $D$8:$D$13 cell range. Sometimes it does, mostly it doesn't. Any help would be great. Thanks.


Eric

"Close the world,txen eht nepO"

 

[GeekGirlau]

Do you have automatic calculation on (Tools, Options, Calculation, Automatic)?

 

[wwgmr]

Yes I do have it set to automatic which is what has me puzzled. It should be doing it.

 

[Dreamboat]

Just a note. If you have one worksheet open that is NOT set to auto-calc, no other worksheets will auto-calc either while that one is open.

Maybe you just need to recover some of your resources:

http://www.piersontech.com/07-CleanHardDrive.htm

techsupportgirl@home.com

http://www.PiersonTech.com

Brainbench MVP for Microsoft Word

 

[wwgmr]

Figured the problem out and feel abit silly for missing it. I had the Abrv in acending order so it wouldn't update or find correct data. Thanks for replies. I been looking to hard at it and missed the simple things lol.