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
Menu
Urgent help
Replies (5)
Could you please attach a file to get the idea of exact problem???
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 ...
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
Agree with jignesh...
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 Threads
- UNCLAIMED TDS REFUND QUERY
- Rcm payable which head
- Query of GST
- Long Term Capitalgains on sale of residential prop
- How Salaried Individuals Can Reduce Capital Gains
- NSTPI registration
- GST PAID IN DELHI
- How to Trade Forex in India?
- TDS - requirement of TDS by individual under presu
- Normal Register in GST in delhi in gujarat no rece
Related Threads
CAclubindia
