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
5 Replies
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 ;)
Recent Topics
- ITC reversal in GST 3B
- Claim if ITC on stocks 19-2020 conversion from com
- Urgent doubt on GST
- Profit or Loss on Sale of Assets Accounting treatm
- Clarification on RCM on Rent Payment for QRMP Deal
- Reclaimed itc in gstr9
- Gamification in Accounting Software: Boosting Enga
- I want to knw Hsn code and gst rate of resin produ
- Schedule FA clarification
- Income tax on freelance income from crypto
Related Threads
CAclubindia
