Excel Lookup formulas
 

Hi,

I have two questions:
1. I notice (occassionally) when I am using Vlookup/Hlookup to import data
to another worksheet that the rules to not immediatley reflect the correct
data. However, if I click on each data cell, and validate the formula (by
clicking on the 'tick') it immediatley returns the correct data. Is there
anyway of doing a bulk refresh that will somehow re-activate the rules that
appear to have become dormant?
2. Is there a formula that will find the largest numeric data entry in a
row, column, array?

Thankyou,

Don-

Re part 2 of your question =max(place range in brackets) should return
largest number.


"Don" wrote in message
...
Hi,

I have two questions:
1. I notice (occassionally) when I am using Vlookup/Hlookup to import data
to another worksheet that the rules to not immediatley reflect the correct
data. However, if I click on each data cell, and validate the formula (by
clicking on the 'tick') it immediatley returns the correct data. Is there
anyway of doing a bulk refresh that will somehow re-activate the rules
that
appear to have become dormant?
2. Is there a formula that will find the largest numeric data entry in a
row, column, array?

Thankyou,

Don-

Don

1. Sounds like ToolsOptionsCalculation is set to "manual". Have a look and
set to "Automatic".

2. Try the MAX Function as in =MAX(A1:A10)


Gord Dibben Excel MVP

On Tue, 27 Sep 2005 01:22:01 -0700, Don wrote:

Hi,

I have two questions:
1. I notice (occassionally) when I am using Vlookup/Hlookup to import data
to another worksheet that the rules to not immediatley reflect the correct
data. However, if I click on each data cell, and validate the formula (by
clicking on the 'tick') it immediatley returns the correct data. Is there
anyway of doing a bulk refresh that will somehow re-activate the rules that
appear to have become dormant?
2. Is there a formula that will find the largest numeric data entry in a
row, column, array?

Thankyou,

Don-