what is vlook up in ms excel and how does it used???



what is vlook up in ms excel and how does it used???..

Answer / harish rawat

vlook up is a way to compayer and match the data or
information of any two sheets.
Like:-

data contain in
sheet 1 sheet 2
A B C A B C
s.n name age s.n name age
1 ram 16 1 monu ?
2 raj 15 2 ram ?
3 monu 19
4 sonu 11

as we see in sheet 2 thir are two name monu and ram but we
don't know there age for that we need to compair sheet 1
and 2.

=VLOOKUP(B:B,Sheet1!B:C,2,0) [note here 0=false]

or
=VLOOKUP(B:B,Sheet1!B:C,2,false)

pls try it and write me your feedback


Harish Rawat
(MCA student)

Is This Answer Correct ?    8 Yes 0 No

Post New Answer

More Databases AllOther Interview Questions

What is lagging in DBMS ?

0 Answers   Hexaware,


What is the Lock Based Protocol used for?

0 Answers   Hexaware,


what is vlook up in ms excel and how does it used???

1 Answers   CybAge,


What is ole db in ssis?

0 Answers  


Given a table Employee which has columns name and salary, write an SQL query to find the employee with the second highest salary.

0 Answers   Amazon,






What is the importance of database partitioning?

0 Answers  


A lowest level of security by most RDBMS is

0 Answers   Baan Infotech,


What is a database lookup?

0 Answers  


How many types of normalization? What is the use of it?

0 Answers   Accenture,


What is odm database?

0 Answers  


Which is the best graph database?

0 Answers  


List various types of log-based recovery in DBMS.

0 Answers   Verifone,


Categories