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 IS CARDINALITIES OF JOIN?

0 Answers  

---

What is Stored procedure ?

4 Answers   IBM, iGate, Inspira Technologies,

---

What is a database call?

0 Answers  

---

i applied prompt on country when i run report it shows list of all countries but want it to show only four countries name

0 Answers   Datamatics,

---

Explain the table term used in database.

0 Answers  

---

---

Is it good to store images in database?

0 Answers  

---

Is database a hardware or software?

0 Answers  

---

What is database client?

0 Answers  

---

what is data set ?

1 Answers  

---

What is dialect in database?

0 Answers  

---

Which is the most reliable programming language for RDBMS Relational Database Management System for Multi user applicaton. For PC application or web application ?

0 Answers  

---

what is meant by Dynamic query?

3 Answers   Satyam,

---