what is LOOK UP formula & how it use in MICROSOFT EXCEL.
please explain with example ?



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

Post New Answer

More HR Questions Interview Questions

what motivates you at work

0 Answers   Abacus, Andhra Bank, Changepond, Flextronics, Nabard,


Why do you want to join Motorola despite being so good in programming?

0 Answers   Motorola,


What qualities would you like to see in your boss?

0 Answers   Wipro,


Tell us some of your strengths and weaknesses.

0 Answers   AAI Airports Authority Of India,


What are you hobbies?

0 Answers   Impetus,






How many flip flops are required to produce a divide by 32

0 Answers   Cisco,


Find the longest palindromic substring from the given string.

0 Answers   Amazon,


Would you lie for the company?

1 Answers   Cisco, Deloitte, EXL, Hexaware,


What do you know about Institute of Banking Personnel?

0 Answers   IBPS,


how do you evaluate your ability to handle conflict?

0 Answers   CarMax, Sherwin Williams,


What are your salary requirements at Waste Management?

0 Answers  


What is your worst character trait?

0 Answers   Bechtel,


Categories