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

Cite.Co is a repository of information and resources created by industry seniors and experts sharing their real world insights. Join Network
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

From India , Vadodara

Attached Files
File Type: xls Query of Excel.xls (244.0 KB, 487 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.

From India , Hyderabad
freeze the range.i m attaching the screenshots how the vlookup should be used.
From India , Lucknow

Attached Files
File Type: xls excel query.xls (338.5 KB, 166 views)

This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.
Add the url of this thread if you want to cite this discussion.

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2020 Cite.Co™