Interested to Buy Any Domain ? << Click Here >> for more details...
what is vlook up in ms excel and how does it used???
- 1 Answers
- 5810 Views
- CybAge, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What is the concept of Virtual field?
wHat Is THE difference between MOVEL and MOVEL(P)……….. CAN ANYONE EXPLAIN ME..
What is a super key?
What are database connection details?
What will happen non-clustered index will be created on clustered index?
What are the advantages of views in a database?
Explain entity type?
Explain the table term used in database.
Given a table Employee which has columns name and salary, write an SQL query to find the employee with the second highest salary.
What do you mean by database?
What is replicaset?
What is a Database?
Can you create a database in word?
What is the Difference Primary key and Unique Key
What is sharded database?
