vlookup double click

Originally Posted by dj_siek

Hi All

I am using a vlookup simple. The vlook up works on some cells but others it wont.

The data its looking up right... i can make them all work BUT i have to go through and double click into the text of the cell its looking up and then just push enter. like forcing it to realise its there or somethign. then the vlookup works?

rather than giong through each cell and double clicking it is there a quicker way i can do it? through a macro or something? i tried to record one but it has the cell specific values when i do it so it wont work.

i hope that makes sense.

Cheers

Joel

Hi,

try Tools, Options, Calculate and see if Automatic or Manual is ticked.

---