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.

rate me as interviewers on a scale of 1 to 10.

0 Answers   Honeywell, Zomato,

---

How many golf balls could you fit into a classic American school bus?

0 Answers   Google,

---

What are the here things that your friends will say about you?

0 Answers   EXL,

---

Have you Interested in doing MS ?

0 Answers   Cisco,

---

What other career options do you have?

0 Answers   GrapeCity,

---

Tell me about your weakness and hobbies?

0 Answers   Ittiam Systems,

---

With your IIT rank and AIEEE rank, why did you chose this particular college?

0 Answers   Adobe,

---

Give an example of a time when you had to make a quick decision on the job?

7 Answers   Siemens,

---

Why Verifone?

0 Answers   Verifone,

---

Why do you want to work with Akamai?

0 Answers   Akamai Technologies,

---

Tell us about your hobbies.

0 Answers   HPCL,

---

Don't you think you are overqualified for this job?

0 Answers   Agilent,

---