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,

---

WHAT IS CARDINALITIES OF JOIN?

0 Answers  

---

Write a query to get maximum and second maximum in oracle?

0 Answers   CGI,

---

Is it good to store images in database?

0 Answers  

---

Display the employees whose salary is less than average salary.

0 Answers   Amazon,

---

Differentiate between unique key and foreign key?

0 Answers   CGI,

---

Which is the best sorting method if i have to sort the students of Harvard University according to their first name?

1 Answers   CybAge,

---

wHat Is THE difference between MOVEL and MOVEL(P)……….. CAN ANYONE EXPLAIN ME..

0 Answers  

---

What is database collection?

0 Answers  

---

what is cardinality

3 Answers   CSC,

---

How do you pass parameter in stored procedure?

0 Answers   CGI,

---

Can we have a function Overloading with same number of arguments but with different return types of function

8 Answers   CybAge, Wipro,

---