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 difference between clustered, non-clustered and unique index?

0 Answers   Abacus,

---

What is a reference table in database?

0 Answers  

---

Source File: Target EMPNO, SAL Empno, Format 101, 1000 101, 1000 101, 1100 101, 1000, 1100 101, 1000 101, 1000, 1100, 1000 101, 10000 101, 1000, 1100, 1000, 10000 102, 1100 102, 1100 102, 1300 102, 1100, 1300 102, 1200 102, 1100, 1300, 1200 102, 1500 102, 1100, 1300, 1200, 1500 How can i get that output using datastage(ETL) tool

0 Answers   Miracle Software,

---

What is lagging in DBMS ?

0 Answers   Hexaware,

---

How do I setup a database connection?

0 Answers  

---

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

8 Answers   CybAge, Wipro,

---

What is the difference between database and server?

0 Answers  

---

What are the differences between Database Trigger and Integrity constraints ?

2 Answers   Synergy,

---

Define stored procedure?

0 Answers  

---

When should you not use firebase?

0 Answers  

---

can any one tell me how i can start database testing mean what should be initial point and how i can write a query for listing page of any item thanks in advance

0 Answers  

---

How do I manually create a database?

0 Answers  

---