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
 

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

If statements in Data Validation 7
Use Formula from another worksheet 3
I need to divide multiple cells by a single control cell in order. 2
Question on looking up data 2
Divide by zero error 3
Need a function 1
Challenge with target output 10
using strings in vlookup function calls 5

Back
Top