How to use last (fourth) parameter of MS Excel VLookUp function efficiently


We have already seen VLookup function with example and precautions need to be taken while using VLookUp function.

VLookup - fourth ( last parameter) example

Read the rest of this entry »

Permanent link to this article: http://www.stepsandtips.com/ms-excel/how-to-use-last-fourth-parameter-of-ms-excel-vlookup-function-efficiently/2295/

Steps and Tips to be remembered while using VLookUp function of MS Excel


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.

VLookup Precautions

VLookup Precautions

Read the rest of this entry »

Permanent link to this article: http://www.stepsandtips.com/ms-excel/steps-and-tips-remembered-while-using-vlookup-function-of-ms-excel/2282/

How to use VLookup function of MS Excel easily


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.

 VLookup function - Student Master

Student Master


Read the rest of this entry »

Permanent link to this article: http://www.stepsandtips.com/ms-excel/how-to-use-vlookup-function-of-ms-excel-easily/2266/

Reserve APSRTC Bus tickets by your Phone with IVRS


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.

Reserve APSRTC Bus tickets by your Phone with IVRS

Steps to book APSRTC ticket by IVRS

Read the rest of this entry »

Permanent link to this article: http://www.stepsandtips.com/how-to-2/reserve-apsrtc-bus-tickets-by-your-phone-with-ivrs/2260/

How to put your favourite window on top of all windows easily


When you are creating any account you need to type all of your details. Instead of typing copy pasting is easy that too from the window which is on the top. If you want to work while watching movie on media player, keeping it on top will be the best thing.

Read the rest of this entry »

Permanent link to this article: http://www.stepsandtips.com/free-software/how-to-put-your-favourite-window-on-top-of-all-windows-easily/2246/

Post Offices also register Amarnat Yatra


Hundred [100] post offices across the country would register Amarnat Pilgrims. Shri Amarnath Shrine Board (SASB) announced the list of the Post offices situated at Uttar Pradesh, Madhya Pradesh, Punjab, Haryana, Bihar and Gujarat which is available at SASB web site.

Read the rest of this entry »

Permanent link to this article: http://www.stepsandtips.com/news/post-offices-also-register-amarnat-yatra/2238/

Older posts «

» Newer posts

”Bloggers