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)

Under which circumstance should you create an index on a table?

0 Answers   3i Infotech,

---

A lowest level of security by most RDBMS is

0 Answers   Baan Infotech,

---

What is lagging in DBMS ?

0 Answers   Hexaware,

---

What are different types of blocks used in stored procedure?

0 Answers   C DAC, CDAC,

---

WHAT IS OPM?(IN DETAILED)

1 Answers   L&T,

---

sparse lookup and where its options we find in OCI and db2?

0 Answers   TCS,

---

What is table scan and index scan?

0 Answers  

---

Explain data independence & its types.

0 Answers  

---

What is difference between clustered, non-clustered and unique index?

0 Answers   Abacus,

---

how can we view column head in first page but not in remaining pages?

0 Answers   TCS,

---

What are the two categories of Client-Server application development?

1 Answers  

---

What do you mean by cluster and non cluster index?

0 Answers  

---