V Lookup Copy Error

[Sekhar]

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.

 

[Yong Heng]

Hi,

Did u fix your table array with "$" ?

It'll be helpful if you provide more information.

 

[Max]

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 somewhere:
=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