what is LOOK UP formula & how it use in MICROSOFT EXCEL.
please explain with example ?
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.
Is This Answer Correct ? | 14 Yes | 1 No |
Why do you have such a low score in 12th?
0 Answers Akamai Technologies, Flextronics,
Why did you choose IT engineering stream?
What do you think it takes to be successful in this career?
Why you want to join TCS? or Why do you want to join TCS and not any other company?
If u r not happy with your job, how will you let your superior know?
how to answer freshers these question "why did you choose your career in IT"?
Find power (x,y) without the use of the pow function.
Rate yourself in vb and com ?
0 Answers DELL, Emirates, HP, Wipro,
What extra-curricular activities are you involved in?
Describe a project you've worked on and how it made a difference.
Why do you want to work with Akamai?
0 Answers Akamai Technologies,
How would you compensate for your lack of experience?