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...


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

How long whould it take you to make a meaningful contribution to our firm?

3 Answers   Lucent,


Tell me about some of your recent goals and what you did to achieve them.

0 Answers   Adobe, Ericsson,


What are your career plans at American Red Cross?

0 Answers   American Red Cross,


How can you relate the goals you have for yourself to the goals of Waste Management?

0 Answers  


Tell me about an important goal that you set in the past.

0 Answers   PNC Bank Financial Services, Waste Management Inc,


Who issues guidelines for providing loans and what is the loan amount percentage for priority sector advances?

0 Answers   State Bank Of India SBI,


Why is technology added to the Banking Sector?

0 Answers   IBPS,


which is your favorite sport? What do you know about it?

0 Answers   RBI,


where do you see yourself in five years

0 Answers   Bechtel,


Do you consider yourself a team player? Give example where you worked in a team and tell us about your role?

0 Answers   TCS,


are you comfortable shifting your base?

0 Answers   DELL,


give an example of how you worked on team.

0 Answers   Starbucks, Subway,


Categories