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)

What are the differences between Database Trigger and Integrity constraints ?

2 Answers   Synergy,

---

What do you mean by foreign key and primary key?

0 Answers   Zensar,

---

what is the difference between tuple calculus and domain calculus ?

2 Answers   Infosys,

---

WHAT IS THE PURPOSE OF TESTING INTEGRITY OF THE UNIVERSE?

0 Answers   Wipro,

---

How do you connect to a database?

0 Answers  

---

Explain phantom deadlock?

0 Answers  

---

Which database is best to store images?

0 Answers  

---

Explain entity type?

0 Answers  

---

How do I setup a database connection?

0 Answers  

---

What is the best database?

0 Answers  

---

Explain inner and outer joins with examples.

0 Answers   Agilent,

---

Explain entity set?

0 Answers  

---