Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> HR Questions
  2. Suggest New Category

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

Question Posted / ajay


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

You're the captain of a pirate ship, and your crew gets to vote on how the gold is divided up. If fewer than half of the pirates agree with you, you die. How do you recommend apportioning the gold in such a way that you get a good share of the booty, but still survive?

0 Answers   Google,

tell me about a time when you made a bad decision.

0 Answers   Ericsson,

How has your college experience prepared you for a career at Burlington Coat Factory?

0 Answers   Burlington,

Tell us about your Educational background?

0 Answers   State Bank Of India SBI,

are you applying for any other jobs?

0 Answers   Apple,

You do not have all the experience we need for this position

0 Answers   Canara Bank, Caterpillar, InterGraph,

what is the new name of gurgaon?

0 Answers   IBPS,

What are the prospects for growth for the person in this job?

0 Answers   Google,

If you had enough money to retire right now, would you?

10 Answers   CMC,

Why Should you leave the current job, you just joined for one month in a company?

7 Answers   Wipro,

What negative points will your friends say about you?

0 Answers   Fidelity,

What is the interest rate currently offered by SBI to you?

0 Answers   Syndicate Bank,

For more HR Questions Interview Questions Click Here
Categories