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)

Which is the best graph database?

916

---

How to produce such kind of file?

1070

---

Why merge statement is used inside the database?

1066

---

aht is the difference b/w network & hierarchial & relational dbms????

2182

---

What is a database example?

944

---

What are different types of blocks used in stored procedure?

1083

---

What is database schema name?

1005

---

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

2024

---

What is redis good for?

936

---

Explain natural key?

1075

---

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

1102

---

Why do we need distributed database?

953

---

What is aws documentdb?

1017

---

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

8458

---

What is the database url?

1033

---