How to Use Vlookup Formula in Excel?

Hello friends today we will discuss about vlookup formula in excel. vlookup formula is one most important formula in excel. Today I will tell you to easy way to use vlookup formula. I hope that will you really enjoy this.

What is Vlookup formula in excel?
When you want to search specific information in your excel worksheet, then you use vlookup formula. Below image show that how to create a specific data to using vlookup formula.

Explaination of vlookup formula 
Vlookup formula is =VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup]

Lookup value- In lookup value shows the cell where you want to see lookup value.
Table array-Table array is a range of the cell in which you see the lookup value. Below image shows that the example of the table array. In this image you see that the selected range of the data is called table array.
Column index number- column index number shows that the column number where you put the vlookup formula in cell.
Range lookup-it is a optional option where you want to fill true or false. True means that approx match the value and False means that exact match the value.

How many ways to open vlookup formula in excel?
There are two way to find vlookup formula in excel spreadsheet.
1. Go to formula tab, in function library group you see lookup& reference click on it, again you see vlookup formula option click on it and use this formula

2.Click the cell where you want to use this formula and type =vlookup(lookup_value, table_array, Col_index_num, range_lookup)

How to use vlookup formula in ms excel?
As we know that When you want to search specific information in your excel worksheet, then you use vlookup formula. Suppose you have range of the data and you want to show specific information then use vlookup formula.
Step 1- Go to the cell, where you want to use this formula
Step 2- Put the formula =vlookup(lookup_value, table_array, Col_index_num, range_lookup)
In lookup value put the cell where you want to see lookup value
In table array select the range of the data
In column index number put column number
In range lookup you want to fill true or false. True means that approx match the value and False means that exact match the value when you have done this work press enter.

If you want to see more example Microsoft office official website.
In this tutorial you have learn about the vlookup formula in excel. If you found any mistake or missing in this tutorial than let me know through your comment. And if you like this article doesn’t forget to like my page on Facebook and also follow me on twitter.

People also read:- Filter in excel.
People also read:- consolidate in excel.

Continue Reading →

Computer Parts and Its Function.

In this last post you have learned about the introduction to computer. Today I will teach you the main component of a pc you also say computer parts. Before starting this tutorial we must have the knowledge of introduction to computer.  I hope that will you really enjoy this.
Images Source- Search on Google

• Mainboard or Motherboard- Mainboard link all the components together and routes of the data. Mainboard is a circuit board which is making up a complex electronic system, such as a modern computer.

It is also known as baseboard, mother of computer, logic board, system board and it also called mobo.

• Central Processing unit- central processing unit is a “brain of computer.”  Processor is a component in a digital computer capable of executing a program. It is also known as Microprocessor or processor.

• Audio card- An audio card is an expansion that facilities the input and output of audio signals from a control of computer programs. Audio card include providing the audio component for multimedia such as video, entertainment, audio etc. Modern computer have not built in audio card, while other requires additional expansion cards to provide for audio capability. It is also known as sound card.

•  Graphics card- Graphic card is a hardware topic. A graphic card also referred to as a graphics accelerator card, graphic card, display adapter etc is an item of personal computer hardware whose function is to generate and output images to a displayed.

• Disc Drive- It is a disk drive that uses electronic magnet waves as part of the process of writing or reading data peripheral device that stored data on disc drive. Most disc drive only read from disc but some disc drive are both recorder and reader.

• CPU cooler fan- As we know its name is cooler fan, simply it is cool our processing unit. You can also say cooling is the process of removing heat from your computer.

• Speakers- speakers enable to listen sound when you see music, movies, play games etc. speakers come in all size and shape. The standard sound connection is 3.5mm stereo jack plug often color-coded lime green for computer audio cards.

• Computer Cabinet- Cabinet is an enclosure that contains the main component of an operating system. Most of a cabinet constructed from steel, plastic, aluminum and other materials. Computer cabinet is also known as simply case, computer box, computer chassis).

Random Access Memory(RAM)
Read Only Memory(ROM)

In this tutorial you have learn about the major component of computer parts. In the next tutorial we were discuss on communication ports. If you found any mistake or missing in this tutorial than let me know through your comment. And if you like this article doesn’t forget to like my page on Facebook and also follow me on twitter.

Continue Reading →