Vlookup function in excel

This query is : Resolved

Linto (Querist)
Follow

14 April 2011 Hi,

can u please explain with a small example what is a vlook up function.Please also let me know the definition and the situation in which this function is being used.

Praveen Bajaj

Praveen Bajaj (Expert)
Follow

15 April 2011 If you need to pull a data-point corresponding to a particular data point, you can use v-lookup. For instance, if you have a sheet with names and age of 200 people. From this you want to pull the ages of 5 particular people in a different sheet, you can use v-lookup.

Download this file for an example and let me know if you have any doubts

https://rapidshare.com/files/457533696/Vlookup_demo.xls