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.

Are you willing to work irrespective of your domain and field of expertise?

0 Answers   BEL,

---

how many edges are there in 3d cube, 4d cube and 2d cube?(Puzzle based questions)

0 Answers   EXL,

---

What are your long-term goals or career plans at Disney Store?

0 Answers   Disney Store,

---

where do you see yourself five years down the line?

0 Answers   Flextronics, IBPS,

---

Who issues guidelines for providing loans and what is the loan amount percentage for priority sector advances?

0 Answers   State Bank Of India SBI,

---

---

What will you do if you're not selected?

0 Answers   HAL, Honeywell, Zomato,

---

Do you have the qualities and skills necessary to succeed in your career at Chevron?

0 Answers   Chevron,

---

Tell me about yourself and why should we hire you when we can promote someone within the organization?

0 Answers   BEL,

---

What are your future plans for this job?

0 Answers   Google,

---

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

0 Answers   Syndicate Bank,

---

If you are asked to reach 5 lac target within a specific period what will be your actions?

0 Answers   State Bank Of India SBI,

---

If given a chance to do something for the society, what will you do?

0 Answers   IBPS,

---