Interested to Buy Any Domain ? << Click Here >> for more details...
what is LOOK UP formula & how it use in MICROSOFT EXCEL.
please explain with example ?
- 1 Answers
- 7178 Views
- I also Faced
- E-Mail Answers
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
Describe your ideal job at NetApp.
What is more important for you - Money or Job Profile?
Tell me about instances when you displayed leadership qualities at your college?
How are the working hours?
Why would you or would you not invest in Apple?
Have you ever had a problem with your peer? Tell us how you handled it.
Why is your CGPA not higher?
describe a situation when you had to convince others.
How did your job change over the years you worked there?
Why do you have low marks in your engineering?
What type of person would you look for this position - if you were the hiring manager?
How long does someone typically stay in this job?
What is your dream - job or dream profile that you would want to work on?
What is an 'Endowment Policy'?
How quickly do you make decisions?
