when i try to update numbers with a vlookup formula , initially all the colums get "0" value . when i individually get to each cell and press F2, the values get updated . How to resolve this issue ?
Regards
Praveen
Praveen CP (--) (274 Points)
12 April 2012when i try to update numbers with a vlookup formula , initially all the colums get "0" value . when i individually get to each cell and press F2, the values get updated . How to resolve this issue ?
Regards
Praveen
CA. Sandeep Kumar Singh
(Deputy Manager (F&A))
(31 Points)
Replied 12 April 2012
Could you please attach a file to get the idea of exact problem???
Harshal Fifadra
(Chartered Accountant)
(1489 Points)
Replied 12 April 2012
Hey while using the vlookup one needs to take care that the data for vlooking up should be the same . For this the $ sign which appears in the vlookup formula needs to be removed .
As a result your query will be solved ..
Ok ...
jignesh l bhatia
(CA)
(78 Points)
Replied 13 April 2012
Hi
Its very simple.
U wud hav kept the "Formulas" as "Manual".Turn it into automatic.
For excel 2007/2010 go to File-options-formulas-Turn it to automatic.
Ur prblm will get solved
Praveen CP
(--)
(274 Points)
Replied 15 April 2012
Hi all, thanks so much..the problem was with manual formula updation..i changed it to automatic and resolved the query !
Thanks for the response/help ;)
GST Live Certification Course (39th Batch) - April 2024 (Weekend Batch) (With Certificate)
"Live class on Python for Financial Analysis: Unlocking Efficiency in Accounting and Finance"
CAclubindia
