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)

Differentiate between extension & intension?

0 Answers  

---

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

0 Answers   Accenture,

---

If we execute an query in MLOAD it's ran successfully, my questions is after successfully ran MLOAD. In error tables we can see anything there! is it possible than what are they?

3 Answers   CTS,

---

What are the advantages of using database?

0 Answers  

---

What advantages does DBMS have over traditional file systems?

0 Answers   ABB, Infogain,

---

How do you pass parameter in stored procedure?

0 Answers   CGI,

---

what are different types of datasets? what are different characteristics or properties of those datasets? what are the advantages and disadvantages of each dataset on each other?

1 Answers   OVGU,

---

How to do performance tunning a database in DB2 V8.2 UDB in linux

0 Answers  

---

I have single column in a file. Input 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15 my output is file 1 have 1,2,3,10,11,12 file 2 have 4,5,6,13,14,15 and file 3 have 7,8,9 how is it possible in datastage

0 Answers   IBM,

---

if we have set auto differencial back up then waht is difference between 1.appen to media 2.over right the existing media

1 Answers   Indian Web Technology,

---

What is database server and how it works?

0 Answers  

---

hai i want to learn oracle apps and i want to put the fake exp of one year so could you please suggest me which is best institute in hyderabad to learn oracle with real time project experience?

2 Answers  

---