Register now or log in to join your professional community.
Vlookup is very important while updated old flies with New file with the same report Example Every month end we will Prepare T&L file for that we have to take new file with last month file to update the same comment.
This will reduce the time which was already updated last month.
Vlookup is a very powerful formula.
If used correctly it can help you search a value and retrieve a particular info based on the variable.
For example, if your data has employee id and you want to retrieve name of the particular employee without going through the entire data list then Vlookup function will most definitely help you.
Practice with easy examples to get a hang of it.
It is really easy and fun to use excel function.
mmmm
you can google it. you can check it on Microsoft Excel help.
in few words, you can use it to retrieve a value based on search criteria.
where you will provide the input value then Vlookup() will search a range of data and retrieve a value from a column you will specify.
VLOOKUP searches for a value in the first column of a table. At the match row, it retrieves a value from the specified column.
Use VLOOKUP when lookup values are located in the first column of a table with information organized vertically. Use HLOOKUP when lookup values are located in the first row of a table, and each "record" appears in a new column.
