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

Please tell me some products/services of BHP Billiton.

1121


Are you willing to work overtime at Capital One?

1056


Why do you want to join Grape City?

1332


Give an example where you demonstrated your organizational skills?

1091


Tell us about your achievements.

1121


state any two of your weaknesses and strengths.

1092


How will you keep your manager informed about what is being done in your work area?

1184


Give an example when you were experiencing peer pressure. How did you handle it?

1124


Do you have the qualities and skills necessary to succeed in your career at Burlington Coat Factory?

1113


what do you prefer- hard work or smart work?

1117


where do you want to see yourself after 5 years?

1004


hello I am a tranee on Mainframe i want to know ans of tricky que like how would u see urself 5 yrs down the line

2603


How do you personally define success?

1188


When is a good time to sell/buy an asset?

1149


What are your short-term and long-term objectives?

1220