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 odm database?

1077

---

How to do Data integrity testing? Who does this testing (Developer or tester)?

2170

---

What are the various ways to execute a query in teradata?

2652

---

How is image stored in database?

1093

---

Explain inner and outer joins with examples.

1218

---

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

3007

---

How default key is different from primary key?

1080

---

Explain normalization in one line?

1156

---

What are the concurrency problems a database faces?

1083

---

Hi, I want do a course in DWH Informatica Administrator and Abinito Administrator please tell me some institute in chennai and i am searching for a job,so please help me and my mail id : satty_rh@yahoo.co.in Thanks, Kumar

2022

---

What is the difference between oracle and MS Access?

1107

---

What is the Difference Primary key and Unique Key

1045

---

How to produce such kind of file?

1152

---

Write a query to retrieve for many to many relationships?

1056

---

What the various ways to tune a teradata query

3331

---