Urgent help

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 

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 ;)

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
Featured 17 November 2026
Chartered Accountant

M/s. A V C & Co.

New Delhi

CA

View Details
Company
ARTICLESHIP 14 November 2026
Articleship Assistant

B Thejas and Associates

Bengaluru

CA Foundation

View Details
Company
19 November 2026
Accounts & Taxation Executive

MCSR and Associates LLP

Hyderabad

CA Inter

View Details
Company
Featured ARTICLESHIP 18 November 2026
Articles

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Foundation

View Details
Company
16 November 2026
Indirect Tax Associate

Sekhri Kanodia & Associates

Mumbai

B.Com

View Details
Company
Featured 29 October 2026
Accounts Executive

Synergy Keystone

Chennai

B.Com

View Details
Company
ARTICLESHIP 20 November 2026
Article clerk

Jain Sanjay Kumar & Co

Jaipur

CA Inter

View Details
Company
30 October 2026
Asst Manager Accounts

Goodwin Pumps India Pvt Ltd

Chengalpattu

CA Inter

View Details