Where's my value?

C

Chi

I created a drop down list using Data Validation (cell C6) from data that I
linked from another workbook onto this worksheet in this workbook. I created
a VLookUp that looks up the value from C6 to return a value in B8:
=VLOOKUP($C6,'By Case'!$A$2:$E$200,2). The formulas work fine, but the
values do not automatically show unless I double click into cell B8 and press
enter. I've tried updating the link, but that didn't do it. Please advise!
Thanks!
 
B

Bob Umlas

Sounds like you may have calculation set to manual. Try
Tools/Options/Calculation & check Automatic.
Bob Umlas
Excel MVP
 
P

Pete_UK

Have you tried pressing F9 (or Shift-F9) to force a recalculation?

Hope this helps.

Pete
 
Top