MS EXCEL

This query is : Resolved

Report Abuse Follow Query Ask a Query

neeraj

neeraj (Querist)
Follow

26 November 2009 Pls. explain OR provide about use of
"vlookup" formula in excel

Kishanlal Paliwal

Kishanlal Paliwal (Expert)
Follow

27 November 2009 You can bring the value from the other excel file to the current file by just looking for the common values in the other file file.

Remember that the cell format for the common value in the both file should be same, for expample numbers, text etc.

In the simple langauge the formula is explained as under;

=vlookup(common value in the current file,define data range in the other file,number of colum in which related data exists in other file,0)

0 is to be put for the search and bring numerical values. You can also use True/False logic.

Rahul Vora

Rahul Vora (Expert)
Follow

28 November 2009 The formula expained by Mr. Kishanlal is correct. Incase, you want to understand with an example, kindly send your mail id on rinkurahul@indiatimes.com. I will send you an actual expample for the same.

Upgrade to CAclubindia Pro. Subscribe Now!