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 long would you stay with Aflac?

0 Answers   Aflac,

---

describe a situation when you had to convince others.

0 Answers   Dunkin Donuts, Rolls Royce, Schlumberger,

---

what are your strengths ?

24 Answers   Satyam,

---

What are your long-term goals or career plans at Ralph Lauren?

0 Answers   Ralph Lauren,

---

I'm concerned that you don't have as much experience as we'd like in…

1 Answers  

---

Why there is a gap in between your career.

2 Answers   IBM,

---

Tell me about a time when you missed an obvious solution to a problem?

0 Answers   Godrej,

---

Who do you think are our most frequent buyers and clients?

0 Answers   Amazon,

---

If you were the hiring manager, what qualities would you try to find in a candidate for this position?

0 Answers  

---

How do you prepare for exams ?

0 Answers   Honeywell,

---

Why do you want to work at X Company?

1 Answers  

---

What attracted you to Videocon?

0 Answers   Videocon,

---