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 CARDINALITIES OF JOIN?

2369

---

Explain natural key?

1142

---

what is ad-hoc access? what is the diff b/w managed query and ad-hoc access?

2313

---

What is a Database?

1776

---

sparse lookup and where its options we find in OCI and db2?

2224

---

What do you mean by cluster and non cluster index?

1079

---

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

992

---

What is the importance of database partitioning?

1062

---

What are different types of clusters present?

1080

---

What is the purpose of firebase?

983

---

What is ole db in ssis?

1057

---

Explain data independence & its types.

1053

---

How to produce such kind of file?

1107

---

Explain inner and outer joins with examples.

1182

---

HOW WE PASS PARM PARAMETERS TO CL VARIABLES FROM RPGLE?

2650

---