View Poll Results: Pls Find the File and Answer about this question
Pls Update File With Regular Formula 7 63.64%
Pls Answer through Email 4 36.36%
Voters: 11. You may not vote on this poll

Articled Clerk
Working As A Mis Executive
+1 Other

I have entered two fields in Excel Sheet1. The two field name was Number and amount. I have also entered same kind of fields in Excel Sheet2 and Sheet3. The Same Kind of Data which are in sheet1 I have entered in Sheet2 and Sheet3 But I have interchanged serial number and amout with rows. For Example In Sheet1 First Number is 650206 and amount is 10000/- Which is in Sheet2 56 Number and In Sheet3 Which is 90 Number.
When I have Use VLOOKUP Formula in Sheet4 with Number then their is a problem in count of Sheet2 Amount and Sheet3 Amount Because if I have take 150 number in Sheet1,Sheet2 and Sheet3 then Sheet1 total amount is display But in Sheet2 Amount after 100 count the =N/A are display and in Sheet3 Amount after 50 Count the =N/A are display Pls Solve this Problem
27th November 2008 From India , Vadodara

Attached Files
Membership is required for download. Create An Account First
File Type: xls Query of Excel.xls (244.0 KB, 472 views)

Hi Hrushik,
It seems that when you gave formula for the sheet 2 in selecting the range you have started it from A580 so when you copied the formula to next cells the values upto A679( which were in the original one) are displayed and after that from A680 in which there are no values are tending to show NA.
So while selecting the range start it from A2 only as in the Sheet1. then your problem will be solved.
3rd December 2008 From India , Hyderabad
freeze the range.i m attaching the screenshots how the vlookup should be used.
8th May 2009 From India , Lucknow

Attached Files
Membership is required for download. Create An Account First
File Type: xls excel query.xls (338.5 KB, 161 views)

Add Reply Start A New Discussion

Cite.Co - is a repository of information created by your industry peers and experienced seniors. Register Here and help by adding your inputs to this topic/query page.
Prime Sponsor: TALENTEDGE - Certification Courses from top institutes like IIM / XLRI direct to device (online digital learning)

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2019 Cite.Co™