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

what ss the difference between recruitment and selection?

1065


Who is your ideal and why?

1124


When given an important assignment, how do you approach it?

1180


What type of boss you would like to work with?

1120


Questions on the projects listed on the Resume.

2513


What's the most difficult decision you've made in the last two years and how did you come to that decision?

1446


What projects did you undertake during your engineering? Describe your role in these projects.

1071


Any question you want to ask from us?

1167


Name three risks that the banks face?

1202


Would you be willing to relocate overseas?

1117


What is the meaning of your name?

1288


you read newspaper regularly? What are some latest headlines?

1197


Tell us about this state's current Chief Minister?

1100


how do you handle problems with customers?

1118


Who won in the India - England ODI Series held in January 2017?

1095