Answer Posted / 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 ole db source in ssis?

948

---

Write a query to retrieve for many to many relationships?

933

---

if i want to display the name of students such that to which city they belong must have count greaer than two

2169

---

Explain entity type?

944

---

What is a trace file?

1027

---

Can you create a database in word?

987

---

Design an ETL process( batch job/script)from source to starting that u will not be dependent on the source in the near future?please elobarate details on what are things to consider.if you'd like to do a diagram that will be great.please answer it

2353

---

what is transaction state, buffer management, shadow paging

3378

---

WHAT IS NEED BY METION DATFMT AND TIMFMT IN H-SEPICITION IN RPGLE?

2911

---

Explain the field term used in database.

918

---

What are the most common databases?

912

---

What is the use of default key?

1083

---

During insert operation in Netezza Connector, if we give direct option as Yes , is there any issue?

1329

---

aht is the difference b/w network & hierarchial & relational dbms????

2162

---

What is table scan and index scan?

1068

---