what is vlook up in ms excel and how does it used???
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
Which is the best graph database?
How to produce such kind of file?
Why merge statement is used inside the database?
aht is the difference b/w network & hierarchial & relational dbms????
What is a database example?
What are different types of blocks used in stored procedure?
What is database schema name?
query to Compare data of two tables between two different Databases(Oracle and SQL Server) Eg., Source Database: Oracle Table: Employee Target Database : SQL Server Table : emp
What is redis good for?
Explain natural key?
Given a table Employee which has columns name and salary, write an SQL query to find the employee with the second highest salary.
Why do we need distributed database?
What is aws documentdb?
please tell me the informatica telecom projects interview question? like if they ask about project explanation and the difficulties and the solutions taken to solve the issues for telecom projects,e.g i am workin for a vodafone project handlin postpaid section,pls tell me wat wud be the process if i work in this ? thanks
What is the database url?