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)

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  

---

WHAT IS CARDINALITIES OF JOIN?

0 Answers  

---

hai if any one having any project sample table structure please froward to my mail id tauseefwst@yahoo.com

0 Answers   HP,

---

How to do Stored procedure testing? Who does this testing (Developer or tester)?

0 Answers  

---

After normalization, what are the conditions which have to keep in mind to de-normalize it?

0 Answers   C DAC, CDAC,

---

how node connect with cpu?

0 Answers   IBM,

---

What is the use of graph database?

0 Answers  

---

can i use the commands "modify" and Change in DB2 to alter my column datatype and its name in a table?

0 Answers  

---

Does aggregate and fact tables gets populated from transactional data with only diffrence in there granularity? Please clarify?

1 Answers  

---

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

8 Answers   CybAge, Wipro,

---

How many types of normalization? What is the use of it?

0 Answers   Accenture,

---

How do you connect to a database?

0 Answers  

---