Skip to main content

Ms Excel: VLOOKUP function

VLOOKUP function in Ms Excel: This function is very useful in ms excel, it simply look up the first column for a value provided and returns the desired value in the same row. Lets have a look on VLOOKUP formula first:

VLOOKUP(value,table,index_number,[approximate_match])

Here
  • value is the actual value which we want to look up in the first column of a table
  • table is two or more columns of data that is sorted in ascending order
  • index_number is the number of column from which value must be returned
  • approximate_match is optional, it can either be 'True' or 'False'. By default it assumed it as 'True'.False is used to find exact match,True is used to get an approximate value.
Now understand this formula with the help of an example. Consider we have following data 

Now, to fetch the student 'Name' (exact value in second column) for a student whose 'Roll number' is '1008', following VLOOKUP formula can be used:
 VLOOKUP(1008, A2:B9, 2, FALSE)
This formula would fetch the value in second column(Name) in the row where 'Roll No' matches to '1008' . This would give us Ella as a result as shown below


Now lets understand the formula with one more example, to fetch the marks in 'Maths' subject (Third column) for Roll No 1004, following formula would be used:
 VLOOKUP(1004, A2:C9, 3, FALSE)




To learn about charts in ms excel Click here




Labels:

Comments

Post a Comment

Popular posts from this blog

MS Excel: 5 most useful shortcuts

 MS Excel: 5 Most useful shortcuts in Excel 1. Shift+space : This shortcut is used to select the single entire row . Hold down the shift key and use up/down arrows to select multiple rows. 2. Ctrl+ space : This shortcut can be time saving to select an entire column . Hold down the shift key and use left/right arrows to select multiple columns 3. Ctrl+T : This is used to quickly insert the table . It would ask where the data is for your table before creating the table. 4. Ctrl+9 : It can be used to hide rows  in a worksheet.Note, hidden rows will not be printed. 5. Ctrl+0 : This is helpful in hiding the columns in a worksheet. Note,hidden columns will not be printed.  Click here to learn about Charts in Excel
Post a Comment
Read more

MS Excel: To create charts

MS Excel: To create charts Ms Excel provides us different type of  charts which can be used according to the demand of data . Following type of charts can be used in ms excel: Pie Chart : It is used to express data in the form of percentage. Bar Chart:  It is used if we want to compare different values related to different categories.It runs horizontally as shown in fig below: Column chart: It is similar to Bar chart, however it runs vertically as shown in below diagram : Line Chart:   To show trend of  data over a span of time this kind of chart is used: Example: Lets us understand how to insert a chart in MS excel with an example. Consider we have a following data in the form of table and we want to display it in the form of chart. To display it in the form chart: Select the data Click on 'Column' under 'Insert' tab to select 'Column chart' Select the chart type to insert the chart 5 Most useful shortcuts in Excel
2 comments
Read more

MS Excel- For beginners

Lets learn basic things about MS- excel. Very first question, What is it? Ms-Excel is a spreadsheet program developed by Microsoft.Using this we can manipulate, format or calculate various arithmetic functions on data arranged in columns and rows.It looks like below: MS Excel basically consists of rows and columns. Rows :  Rows consists of horizontal lines, two parallel horizontal lines make a row as shown in fig below:   Here first row is selected. Number 1 represent row number 1 and similarly each number represents respective row number. Columns: Columns consists of vertical lines, two parallel vertical lines make a column as shown in fig below:   Each column is identified by a different alphabet as first column is marked as A.  Cell : A cell is a rectangular box which occurs as the result of intersections of rows and columns as shown below:               How to perform various arithmetic...
1 comment
Read more