How to apply VLOOKUP formula in MS Excel | Find data from other Table by vlookup
In this video I'll tell you
How to apply VLOOKUP formula in Microsoft Excel.
Find data from other table by using vlookup in MS Excel.
This is very useful excel tip. Vlookup is used to place values from other table in excel. It is also used when we need to find value of certain item from data table.
Let's go see how to use it.
First of all , select your all data from that table from where you have to place value.
After selecting all cells give TableArray name.
Than go to that table where you use vlookup formula.
Write following formula.
=VLOOKUP(Lookupvalue,TableArray,ComnIndex,False)
In this formula
Lookupvalue is that cell whose value we have to find from data table.
TabbleArray is name of that table which we have given after selecting all data.
ColmnIndex is number of column in data table.
False is used for exact match
You have to write formula for one time after that you can find values by giving only one cell data.
I hope you will learn a lot from this video.
Please subacribe my channel for more videos.
Thanks for watching