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 ?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

You have stayed with your current company for a long time. Why?

1322


which topology exists in your college?

1144


Any questions that you would like to ask me?

1133


How was the pre-placement talk useful?

1212


What motivates you to work for HCL Technologies?

1702


You seem to be over-qualified and too experienced for this job. What you have to say?

1232


Do you know anyone who works with Ross Stores?

1116


Are you comfortable working late nights, if project demands?

1217


What is your style of management

1120


What are you expecting from Kaiser Permanente in the future?

1094


Tell us something about history of our freedom movement?

1161


Justify why you prefer COD/ online payment?

1158


What salary range are you looking for at Aflac?

1195


How would a professor who knows you well describe you ?

1192


What are the current happenings that are taking place in the banking industry?

1152