Some quick diagnostics ...
1. Is calc set to manual mode? Press F9. Does it compute?
To check/change calc mode: Click Tools Options Calculation tab
Set it to "Automatic"
2. Data is inconsistent between the lookup values/lookup col in the ref
table,
eg text numbers vs real numbers
Try these variations:
=VLOOKUP(A1+0,TableArray,2,0)
make the lookup value into a real number
=VLOOKUP(A1&"",TableArray,2,0)
make the lookup value into a text number
=VLOOKUP(TEXT(A1,"000000"),TableArray,2,0)
make the lookup value into a text number, padded with leading zeros (6 digits)
Or, if its text phrase lookups,
maybe there's extraneous white spaces somewhe
=VLOOKUP(TRIM(A1),TableArray,2,0)
TRIM removes the extraneous white spaces in the lookup
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,000 Files:358 Subscribers:55
xdemechanik
---
"Sekhar" wrote:
when i copy a v-lookup formula in a col I am getting the value which it
returned in the 1st cell throughout the col.
Unless I am manually get into the cell and do enter, I am not able to see
the correct value returned by the formula for that cell.
Why does this happen? Can anybody help? Thanks in advance.