Vlookup function in excel


This query is : Resolved 

(Querist)
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.

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


You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now



Similar Resolved Queries


loading


Unanswered Queries



CCI Pro



Answer Query



Company
ARTICLESHIP 14 November 2026
Article Assistant

Jitendra Agarwal & Associates

Bengaluru

CA Inter

View Details
Company
ARTICLESHIP 20 October 2026
CA ARTICLE

AMKN & CO

Noida

CA Inter

View Details
Company
02 November 2026
Audit Executive

SRJP & Co LLP

Kochi

CA Inter

View Details
Company
ARTICLESHIP 22 October 2026
Articleship intern

Srinath Manikanta

Hyderabad

CA Inter

View Details
Company
ARTICLESHIP 25 October 2026
Article Intern (CA Articleship)

Arpan Bohra & Co

Hyderabad

CA Inter

View Details
Company
16 November 2026
Assistant Article

ZAK & Co. Chartered Accountants

Bengaluru

CA Inter

View Details
Company
24 October 2026
CA Industrial Trainee

Fytomax Nutrition Private Limited

Aurangabad

CA Inter

View Details
Company
16 November 2026
Indirect Tax Associate

Sekhri Kanodia & Associates

Mumbai

B.Com

View Details