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 |
What is lagging in DBMS ?
What is the Lock Based Protocol used for?
what is vlook up in ms excel and how does it used???
What is ole db in ssis?
Given a table Employee which has columns name and salary, write an SQL query to find the employee with the second highest salary.
What is the importance of database partitioning?
A lowest level of security by most RDBMS is
What is a database lookup?
How many types of normalization? What is the use of it?
What is odm database?
Which is the best graph database?
List various types of log-based recovery in DBMS.