Answer / sreekanth

VLOOKUP Formulas in Microsoft Excel
The following graphic provides a breakdown for a VLOOKUP
formula, and describes each argument. It may be helpful to
review it before you continue reading the rest of the
article. The V in VLOOKUP means "vertical". HLOOKUP works
similarly, but finds data going across columns, instead of
down rows.



VLOOKUP has many purposes. You can quickly create a
pricelist that is thousands of rows long on Sheet2. On
Sheet1, you can designate a cell into which to type a part
number, and then have a VLOOKUP that finds the price on
Sheet2. No scrolling, no need to use the Find feature to
find the price for the part.

The following graphic demonstrates how to look up the
salary of only several employees. Note that the VLOOKUP
formula in cell D2 is shown in the formula bar.



So, what's MyLookup? That's our data range or database"
where the Salary table lies, which is demonstrated in the
following graphic.

From where did you do your graduation?

0 Answers   Blue Star,

---

Any body know that dell do a background check or not?

4 Answers   DELL, Wipro,

---

What things make you angry? How do you handle yourself in such a situation?

0 Answers   Zensar,

---

What are HP's objectives for the coming year?

0 Answers   HP,

---

If your boss asks something to do unethical then would you be ready?

0 Answers  

---

A ball is dropped from the top of 8 m building. It bounces back half the drop. So when it will be still how many distance would it have travelled.

0 Answers   Huawei,

---

Tell us about an experience where you had been a team member.

0 Answers   Ashok Leyland,

---

There's a bond of 2 years ……. you' re ok with it?

0 Answers   TCS,

---

what has been your greatest achievement till now?

0 Answers   Expedia, GrapeCity,

---

Tell me about your work experience? How has it prepared you for a career at BHP Billiton?

0 Answers   BHP Billiton,

---

What do you know about the latest crop insurance scheme started for farmers?

0 Answers   IBPS,

---

How do you prepare for exams ?

0 Answers   Honeywell,

---