We have already seen VLookup function with example and precautions need to be taken while using VLookUp function.
PPF (Public Provident Fund) received the consensus of major Personal Finance experts due to its unique benefits. Even-though it offers incomparable benefits, some hidden losses also there. I am furnishing five losses, which may not applicable to all but someone may affect.View full post
How to work fast and easily with Windows..? How to get daily and most frequently doing actions of windows at one place..? How to get most advanced explorer than windows explorer..? For those who are expecting answers for these sought of questions i am introducing a free software which makes working with windows still more …View full post
Google spreadsheets are now more strengthened with Pivot Tables. Pivot tables are dynamic tables which provides easy way to analyze spreadsheets without using any formula. Who regularly works with spreadsheets knows very well about Pivot Tables. But for new users i will explain with example. Let us assume Students information with Name, Class, Section, Maths …View full post
Google catalogs is a free google application for tablets, which makes your shopping easy by enabling you to browse all of your favorite catalogs and interact with new layers of rich-media content.View full post
Permanent link to this article: http://www.stepsandtips.com/ms-excel/how-to-use-last-fourth-parameter-of-ms-excel-vlookup-function-efficiently/2295/
VLookup is very easy and useful of function MS Excel. It can provide solutions for many types of complex operations in Excel easily. But many excel users feels that VLookup is complex. But if you read this VLookup Example and the following precautions you will say that VLookup is not a complex function.
Permanent link to this article: http://www.stepsandtips.com/ms-excel/steps-and-tips-remembered-while-using-vlookup-function-of-ms-excel/2282/
What is (Purpose of ) VLookup function of MS Excel
VLookup (Vertical Lookup) is an useful function of Microsoft Excel which searches first column of a given range against the given value (lookup value) and returns one desired column value from the founded row.
To understand VLookup function more clearly we see one example. Let say School X is maintaining Students information in multiple sheets.
First Sheet (Master) contains students master data, like Student Number, Name, Father Name, Mother Name, Date of Birth, Class etc.
Permanent link to this article: http://www.stepsandtips.com/ms-excel/how-to-use-vlookup-function-of-ms-excel-easily/2266/
APSRTC (Andhra Pradesh State Road Transport Corporation) started India’s first IVRS (Interactive Voice Response System) Ticket booking System. Mr.B. Prasada Rao , M.D. , APSRTC Yesterday (08th May, 2012) announced this most useful facility along with Mr. C.H. Sudhakar Reddy, M.D. Abhibus developer of this system.
Steps to book APSRTC ticket by IVRS
Permanent link to this article: http://www.stepsandtips.com/how-to-2/reserve-apsrtc-bus-tickets-by-your-phone-with-ivrs/2260/
Permanent link to this article: http://www.stepsandtips.com/free-software/how-to-put-your-favourite-window-on-top-of-all-windows-easily/2246/
Permanent link to this article: http://www.stepsandtips.com/news/post-offices-also-register-amarnat-yatra/2238/