HOW TO USE EXCEL'S VLOOKUP FUNCTION

VLOOK UP - 

VLOOKUP is the main frame formula of Excel. Vlookup is an extremely useful tool.

Basically, VLOOKUP lets you search for specific information in your spreadsheet.

Here we learn how to use VLOOKUP function in easier way, with example. 

The below example is simple. Once you learn how to use VLOOKUP, you will be able to use it with, larger more complex spreadsheets and that's when it will become truly useful.


USE OF VLOOKUP :-

As you see in above picture there are Products & how much Order Place for them. This is the Sheet 1 of spreadsheet. Here are 9 Products Catagory.

Now we are on Sheet 2 of same spreadsheet, You can also check this with another spreadsheet.
As you see in above picture that Product Catogories are same but the locations are random, they are not at same place as which shown in 1st picture.
Now If there are 2 - 4 Product Catagories then you find from another spreadsheets and wrote down the Order Place quantity manually.
But if the Product Catogory is in thousands (,000) then it is possible to find one by one and wrote down the Order place quantity.

So now we use VLOOKUP Function.

As shown in above picture, Where we want to place the value (Here Order Place Quantity), On that cell write =vlookup( as shown in picture or you can take this from formula Bar.

Now, as shown in above picture select the look_value which is are here are products from (B2:B10) cells. 

After selecting lookup_up value we need a table array

For table_array now we are on Original Sheet , here which is Sheet 1, Now after lookup_table put a comma (,) and select table_array which is original sheet from (B2:C10).

After selecting table_array, now we have to put collumn index no.

As shown in above picture we have put 2 for collumn index no. 2 is here for collumn from which vlookup function took the value randomly.

If you have a spreadsheet which also has 3rd collumn and and you want to take value from 3rd collumn then you put here No. 3

After this col_index_no. we have to put range no. which is 0 as shown in above picture.

After this close the ) (bracket)

Here we found how much order we place for DVD which is "4".

In original sheet (Sheet 1) DVD was on 7th Place, and in another sheet (Sheet 2) DVD is on 1st Place. But from the VLOOKUP function it automatically place the value of DVD.

Now go to formula and put Dollar sign ($) as shown in above picture for lookup_value and for table_array.

Dollar ($) sign is for freeze the cell. If we don't freeze the cell and when locations get change the formula change the cell location.

So it is necessary to freeze the cell.

 After then copy the C2 cell and paste it from C2 : C10 here we found all the quantity (Order Place Value) as we have in 1st sheet.



Hope you understand how to use VLOOKUP function,  and this information is useful for you.

Thanks