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 lagging in DBMS ?

0 Answers   Hexaware,

---

Explain about ur projets on teradata???

0 Answers   Wipro,

---

What is the advantage of varchar2 over char?

0 Answers   ADITI,

---

Differentiate between unique key and foreign key?

0 Answers   CGI,

---

What is dialect in database?

0 Answers  

---

If the master device is full, how do I make the master database bigger?

0 Answers  

---

query to Compare data of two tables between two different Databases(Oracle and SQL Server) Eg., Source Database: Oracle Table: Employee Target Database : SQL Server Table : emp

0 Answers   Verizon,

---

Explain artificial key?

0 Answers  

---

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

1 Answers  

---

how to implement dense rank in rank transformation in Informatica? so that output should be like 1,1,2,3 and not like 1,2,3,4

1 Answers  

---

First input columns brand, mt, re values are ov, 1,re vg, 2,re wu ,3,re. Second input columns are brand, mt, cx their records are ov,4,vg ,5,cx Wu, 6,cx and third input columns brand, mt, rt values are ov,7,rt vg, 8,rt wu, 9,rt but my output is brand, re, cx,rt values are ov, 1,4,7 vg, 2,5,8 wu, 3,6,9

0 Answers   IBM,

---

what is transaction state, buffer management, shadow paging

0 Answers  

---