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.

If I were to ask your professors to describe you, what would they say?

1 Answers  

---

You have 5 jars of pills. Each pill weighs 10 grams, except for contaminated pills contained in one jar, where each pill weighs 9 grams. Given a scale, how could you tell which jar had the contaminated pills in just one measurement?

0 Answers   Cap Gemini,

---

How many hours a week do you normally work?

1 Answers  

---

What do your parents think about you?

0 Answers   HAL,

---

If given a chance to you to change one thing in the society, what will it be and why?

0 Answers   IBPS,

---

How you doing?

0 Answers   CGI,

---

What do you like and dislike about our company?

6 Answers   Lipco, Lucent,

---

Why do you want to become an investment banker and is there anything that puts you off working in investment banking?

0 Answers  

---

Explain the significance of “dead beef”?

0 Answers   Google,

---

How do adjust to a new environment ?

0 Answers   Honeywell,

---

How will you work for the next 60 days if you are selected?

0 Answers   Ericsson, GE,

---

If you worked for Buffalo Wild Wings, what are you doing?

0 Answers   Buffalo Wild Wings,

---