We have already seen VLookup function with example and precautions need to be taken while using VLookUp function.
Good news for users who are using Google Chrome and Safari browsers (web kit compatible browsers). Google launched new mobile gadget like looking iGadget Gmail gadget. As you know igoogle personalise your google home page as you like, provides all the gadgets which you think useful at one place. This new Google gadget is similar …View full post
Sri Medaram Sammakka Saralamma Jatara is the most popular festival celebrated in Andhra Pradesh once in a two years. Pilgrims from all over india visits Madaram for the blessings of Goddess Sri Sammakka and Sri Saralamma(Sarakka). It is also called Madaram Jatara which can be compared with Kumbha mela.View full post
Bajaj is a well known brand in India which is famous for its products in Automobiles, Electronics etc. Bajaj Allianz is a joint venture between Bajaj Finserv Limited and Allianz SE. To meet the increasing demand in Term Insurance Bajaj Allianz come up with online term insurance plans. BAJAJ Allianz iSecure loan term Insurance PlanView 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/