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.

How did you come to know about Grape City?

0 Answers   GrapeCity,

---

what is your dream company?

9 Answers   AB InBev, Amazon, Bajaj, EXL, ITC Indian Tobacco Company,

---

How do you let subordinates know what you expect of them?

0 Answers   TK Maxx TJ Maxx,

---

Tell us about economy of India.

0 Answers   State Bank Of India SBI,

---

What qualities do you look for in a boss?

8 Answers   CMC, TCS,

---

why do you want to work at essar?

0 Answers   Essar,

---

LG Electronics India uses three psychometric tests to measure a person's ability as a team leader,to check personality types and to find a person's responsiveness and assertiveness. these tests are first validated against various reliability and validity standards and then used to select people. Explain what are these standards to check validity and reliability of tests?

1 Answers   HZL,

---

how many languages do you know?

0 Answers   Nabard,

---

Which is your favorite subject?

0 Answers   NIIT,

---

What kinds of decisions are most difficult for you at Henkel?

0 Answers   Henkel,

---

Why you go so less percentage in X and XII in comparison to your B.Tech degree?

0 Answers   Blue Star,

---

Could you have done better in your last job?

1 Answers  

---