Where's my value?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
Sounds like you may have calculation set to manual. Try
Tools/Options/Calculation & check Automatic.
Bob Umlas
Excel MVP
 
Have you tried pressing F9 (or Shift-F9) to force a recalculation?

Hope this helps.

Pete
 
Back
Top