Apply of Vlookup for comparison and entry feeding

For the compression of two datasheet lookup is more helpful for us. We are comparison the sheet and find out the extra data and missing data in both sheets (Example No – 1 ). It is also utilized to entering the value depends in the other value and make time-saving and error Free Entry. (example No - 2)

In Example No – 1 we are comparison Sheet No -1 to Sheet No -2 and find out the difference from sheet no – 2

Sheet No – 1

Sr. No	Name	Bank A/c No	Amount
1	Kamal	22658	5000
2	Rohit	65894	4000
3	Mohit	25689	3000
4	Sohan	45985	4500
5	Mak	45894	2500
6	Ganesh	45896	32500
		Total	51500

Sheet No - 2

Sr. No	Name	Bank A/c No	Amount
1	Ganesh	45896	32500
2	Kamal	22658	5000
3	Mak	45894	2500
4	Mohit	25689	8000
5	Rohit	65894	4000
		Total	52000

Apply the formula in sheet no -1

Before the apply the formula we consider the common and same value in the same sheet.

In the booth sheet bank, a/c no is the same so we are apply vlookup in bank a/c no

Sr. No	Name	Bank A/c No	Amount
1	Kamal	22658	5000	=VLOOKUP(C2,'sheet no -2 '!C:D,2,FALSE)
2	Rohit	65894	4000
3	Mohit	25689	3000
4	Sohan	45985	4500
5	Mak	45894	2500
6	Ganesh	45896	32500
		Total	51500

In lookup first, we are select common value so we are select c2 because bank a/c no is common, after that take comma and select sheet no -2 and select all C To D Columns  and in the time of selection no of select columns is show enter the no of the column we show the value and type false ( for Exact value match and true app value match ) after the enter, you show sheet no – 2 vale and copy the formula in all the column you show that value

Sr. No	Name	Bank A/c No	Amount
1	Kamal	22658	5000	5000
2	Rohit	65894	4000	4000
3	Mohit	25689	3000	8000
4	Sohan	45985	4500	#N/A
5	Mak	45894	2500	2500
6	Ganesh	45896	32500	32500
		Total	51500

It means that Sohan is not entered in sheet no – 2 because of that value shows that not applicable and Mohit take 8000 rs in sheet no -2 and sheet -1 shoe value of Rs 3000   

End of Example No – 1

Example No – 2

We have Data sheet of Emp.  In sheet -1

Emp No	Name	Father Name	Bank A/c No
105	Muktyar	Dinesh	22658
106	Rohit	ritesh	65894
107	Mohit	Hem bahadur	25689
108	Sohan	jin	45985
109	Mak	lokesh	45894
110	Ganesh	jitender	45896

We are main the bank file for amount distribution we are enter only Emp No and amount, another field is automatic shoe

We maintain file below format

Emp.No	Amount	Name	Bank  a/c No
105	5000	=vlookup(A2,'sheet1'!A:B,2,false)	=VLOOKUP(A2,'sheet1'!A:D,4,false)

After entering in the name show the name of Emp and Bank a/c No Copy or drag formula in the column you enter only Emp no and Amount name and bank a/c no automatic show, Like this

Emp.No	Amount	Name	Bank  a/c No
105	5000	Muktyar	22658
109	2500	Mak	45894
106	1254	Rohit	65894
107	1254	Mohit	25689
109	256	Mak	45894
		#N/A	#N/A
		#N/A	#N/A

In the above formula care that first one select common filed, second select sheet no -2 and common filed is the first field and select column we want the show, total no of columns between first and wanted columns and true or false.

For further query contact us

Kamal Kumar

Ph.9996480619

Accounting , Tax Service Soluation in Rohtak

                 OMKARA CONSULTANCY SERVICE

Omkara Consultancy is Provide solution for Accounting , Finance, Human Resource ,Income Tax Return , TDS Return, Excise Sale Tax , Service Tax Return , EPF Return , ESI Return Etc..Account Book and Above all Service is provide by different professional. Also provide Data Entry Service, Survey. Project Report, DBMS Service, Online Financial Record .

Contact No- 9996480619  (kamal Kumar)
Email         :   Kamal@omkara-consultancy.com
                     contact@omkara-consultancy.com     

Sr.No.	Nature of Payments	Period	Due Date of Payment	Due Date of Submission of Return
1.	TDS	Deducted during the month From April to February	7th of Next Month	15th of next month after completion of each Qtr
2.	TDS	Deducted during the month of March	On or before 30th April	15th May
3.	Excise	For All Assesses except SSI & If Period of Removal of Goods is from April to February	5th of Next Month	10th of Next Month
4.	Excise	For All Assesses except SSI & If Period of Removal of Goods is in the month of March	31st March	10th of Next Month
5.	Excise	For SSI & If Period of Removal of Goods is from April to February	5th of Next Month	20th of following qtr(Qtrly return)
6.	Excise	For SSI & If Period of Removal of Goods is in the month of March	31st March	20th of following qtr (Qtrly return)
7.	Excise	For First stage and Second Stage Dealer		15th of month succeeding completed quarter
8.	Service Tax (Corporate,Trust, Societies)	If Service tax charged on revenue from April to February	5th of Next Month (For e-payment 6th of Next Month)	Half year ended on 30th Sep, return to be filed by 25th October
9.	Service Tax (Corporate,Trust, Societies)	If Service tax charged on revenue in the month of March	31st March	Half year ended on 31st March, return to be filed by 25th April
10.	Service Tax (Individual, LLP,firm, proprietorship)	April to Dec( for 3 qtrs)	5th of the month after end of each quarter (For e-payment 6th of the month)	Half year ended on 30th Sep, return to be filed by

Reset password in Income Tax india efilling (for efilling your ITR)

Dear Friend,

Most of people e filling there ITR from consultant or profession people. and they are not fill there user name and personal detail. and some consultant DO not share the Detail they are set in personal information. and people face problem to Login there account and filling of ITR.


For Complete of these process you are reset you Password


Step -1   Go to home page of income Tax india efilling (https://incometaxindiaefiling.gov.in/)
Click on  Log in here  below of Registered User

after that You see below page   (https://incometaxindiaefiling.gov.in/e-Filing/Services/ForPaswd.html)

User ID

Password

Login         Forgot password


Click on forget password


NEW FORM OPEN

ENTER PAN NO

ENTER IMAGE SHOW

AFTER THAT PRESS CONTINUE BUTTON


STEP NO-2


THREE OPTION AVAILABLE FOR RESET PASSWORD


OPTION NO-1

Enter answer of secret Question (Set in time of Profile creation)

and Date of birth

click on validate and enter New Password renter NEW Password and password Reset



OPTION NO - 2

NSDL And Pan Center create DSC , With Help of DSC you are reset the password. Dsc is made of one year or two year and help full of efilling your ITR


OPTION NO-3

ENTER ASSESSMENT YEAR                               2010-11
ENTER  ACKNOWLEDGEMENT NO
BANK ACCOUNT NO

ENTER VALIDATE BUTION AND RESET YOU PASSWORD



Note : If you're not able to reset the password with any of the three options above,
please send an email to - validate@incometaxindia.gov.in with the following details
PAN
PAN holder's Name
Date of Birth / Date of Incorporation
Father's Name
Registered PAN address
On successful validation, the password will be sent to your Registered Email.


For other Detail Contact me

Thanking You,


Kamal Kumar
Ph. No-9996480619