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

What’s your greatest strength?

1 Answers  


what do like and dislikes of this jobs ?

6 Answers   TCS,


what kind of music do you listen to?

0 Answers   HAL, Honeywell, Zomato,


Why do you want to work for BlackRock?

0 Answers   BlackRock,


Tell me some of your strengths and weaknesses..

0 Answers   Cisco,


Do you have anything to ask us?

0 Answers  


I have cleared technical,Hr round in Polaris on 30th April 2010 .The hr also told me that she will send me the offer letter in a day.But i have not received offer letter yet.Why is it getting delayed?Will i get this offer? Plz let me know

12 Answers   Polaris,


What opportunities does a financial downturn present to financiers?

0 Answers  


explain why I should hire you.

1 Answers  


Why do you want to join Atos?

0 Answers   Atos Origin,


Will you be ready to shift to the different site locations our company operates at?

0 Answers   HPCL,


Why did you decide to pursue your career at Applebees?

0 Answers   Applebees,


Categories