lookup or vlookup

  • Thread starter Thread starter sjk
  • Start date Start date
S

sjk

the functions do not complete their tasks for all 600
rows automatically. I must click on the lookup cell then
click on it in the little box above with the "=" sign in
front of it. Then if I click in the cell with the
function and references it returns the correct looked up
info. Extra wierd. Anybody have any ideas? Thanks
 
sjk said:
the functions do not complete their tasks for all 600
rows automatically. I must click on the lookup cell then
click on it in the little box above with the "=" sign in
front of it. Then if I click in the cell with the
function and references it returns the correct looked up
info. Extra wierd. Anybody have any ideas? Thanks
Click to expand...
You would see this behavior if Calculation was set to Manual.

You can change the Calculation mode by going to Tools | Options |
Calculation(tab) and selecting which mode you want. Automatic is the
most common and generally useful. Manual can be helpful for certain
types of spreadsheets (often they are very large).

If you want to leave the Calculation mode as Manual, you can use the
F9 key to calculate the workbook on command.


Hope this helps,

Matthew
 
-----Original Message-----

You would see this behavior if Calculation was set to Manual.

You can change the Calculation mode by going to Tools | Options |
Calculation(tab) and selecting which mode you want. Automatic is the
most common and generally useful. Manual can be helpful for certain
types of spreadsheets (often they are very large).

If you want to leave the Calculation mode as Manual, you can use the
F9 key to calculate the workbook on command.


Hope this helps,

Matthew

.Thanks. Tried that every which way to no avail. sk
Click to expand...
 
If you see the formulas in the formula cells instead of results,...

Activate Edit|Find.

Find what:

=

Replace with

=

If this is not the case, try to be more specific: For example, What are the
lookup values -- numbers?
 
Back
Top