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

808

---

What is database and its types?

554

---

issues involved in modeling and building data werahouses

1547

---

What is the database url?

550

---

how can you perform lookup range in lookup stage expalin in detail?

1518

---

---

how do you do sql tuning?

1596

---

What are the advantages of normalizing a database.

593

---

Is redis in memory database?

534

---

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

1632

---

Give the syntax of exception handling used in DBMS?

647

---

What is dialect in database?

549

---

What is ole db used for?

576

---

What is the function of cluster index?

610

---

What is sharded database?

504

---

HOW WE PASS PARM PARAMETERS TO CL VARIABLES FROM RPGLE?

2143

---