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 Topics :
- Itr 4 problem
- Capital Gains Mismatch Due to Sale Agreement in FY
- REGARDING NRO INVESTMENT IN SHARES OF DOMESTIC COM
- DTAA benefits
- SUPPLEMENTARY AGREEMENT FOR ADDING A PARTER IN TN
- Part availmement of ITC in case of rejection of su
- Due date for itr 5 no audit with loss for fy 25 26
- Capital Gains Mismatch AIS
- Inward E-way bill from Tally Prime 7.1
- Query regarding exemption under Section 10(10AA) &
Related Topics :
CAclubindia
