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)

How does non-cluster index functions?

1131

---

what are wrappers and build ups and what it's use?

2158

---

Differentiate between unique key and foreign key?

1008

---

Two tables emp(empid,name,deptid,sal) and dept(deptid,deptname) are there.write a query which displays empname,corresponding deptname also display those employee names who donot belong to any dept.

1893

---

What are the disadvantages of views in a database?

1053

---

What are the most common databases?

971

---

What is the difference between database and server?

1018

---

What is the candidate key used for?

1087

---

What is Data Modelling?

1077

---

What is ole db source in ssis?

995

---

What is odm database?

1008

---

Is it good to store images in database?

1000

---

What is the concept of Virtual field?

2054

---

What is lagging in DBMS ?

1256

---

After normalization, what are the conditions which have to keep in mind to de-normalize it?

1048

---