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 :
- FAST DS 2026 query
- Consultation
- E-way notices for FY 22-23
- Gst file not created
- Regarding 3CEB query
- Omitted E-Commerce Sales Reported in Table 14 but
- Omitted sales shown in GSTR-1 Table 14 but not in
- EWAY BILL TAKE OUT OF OTHER COMPAMY
- Penalty & late fee for late ITR filing
- Business discontinued as Government took possessio
Related Topics :
CAclubindia
