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.

WHY DO YOU WANT TO LEAVE YOUR PRESENT JOB?

3 Answers  

---

What was the toughest decision you have ever had take?

0 Answers   Genpact,

---

What is the reason for joining Maruti and not a technical firm

0 Answers   HPCL,

---

Introduce yourself. What are your hobbies?

0 Answers   Adobe,

---

How have you completed both BSc botany & BCA in 2010?

0 Answers   Syndicate Bank,

---

What do you see as the most difficult task in being a manager?

0 Answers   Apple,

---

Tell us about your Educational background?

0 Answers   State Bank Of India SBI,

---

how many projects do you work on at once?

0 Answers   Kaiser Permanente, State Street,

---

What will you do in case if you are posted away from home?

0 Answers   State Bank Of India SBI,

---

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

0 Answers   Capital One,

---

Why should you get promoted

4 Answers   Cap Gemini, Mastek,

---

tell me about yourself and your achievements.

0 Answers   Honeywell, Huawei, Zomato,

---