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
You have stayed with your current company for a long time. Why?
which topology exists in your college?
Any questions that you would like to ask me?
How was the pre-placement talk useful?
What motivates you to work for HCL Technologies?
You seem to be over-qualified and too experienced for this job. What you have to say?
Do you know anyone who works with Ross Stores?
Are you comfortable working late nights, if project demands?
What is your style of management
What are you expecting from Kaiser Permanente in the future?
Tell us something about history of our freedom movement?
Justify why you prefer COD/ online payment?
What salary range are you looking for at Aflac?
How would a professor who knows you well describe you ?
What are the current happenings that are taking place in the banking industry?