what is LOOK UP formula & how it use in MICROSOFT EXCEL.
please explain with example ?
Answer Posted / 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.
Is This Answer Correct ? | 14 Yes | 1 No |
Post New Answer View All Answers
What are the major challenges of the High Tech and Insurance industry?
Tell us something about yourself that is not on your resume.
How do you let subordinates know what you expect of them?
how do you plan to achieve your goals?
What kind of a manager are you?
What are your interests and hobbies? How do you spend your free time?
What will be Your attitude towards customers in bank?
what makes you choose this job profile?
Do you have what it takes to work under pressure? What makes you angry?
What are you expecting from Farmfoods in the future?
Describe a situation in which you had to collect information.
What are your future goals? Do you wish to change your career path in the future?
Why do you want to Join Huawei?
What is optimal stopping theory?
If 15 tasks are given at a time what will you do?