Question about Microsoft Excel for PC

3 Answers

What is vlook up & what is hlook up? - Microsoft Excel for PC

Posted by on

3 Answers

  • Level 1:

    An expert who has achieved level 1.

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that has over 10 points.

    Mayor:

    An expert whose answer got voted for 2 times.

  • Contributor
  • 24 Answers

Excels Definitions:
Vlookup: Looks for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify. By default the table must be sorted in ascending order.
Hlookup: Looks for a value in the top row of a table of values and returns the value in the same column from a row you specify.
Easiest way to both find these out and work out how to use them is to click the "fx" button which appears above the spreadsheet window in excel next to the tick and cross symbols. You can then search through all excels functions for extra information.
hope that helps.

Posted on Mar 14, 2011

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Governor:

    An expert whose answer got voted for 20 times.

    Scholar:

    An expert who has written 20 answers of more than 400 characters.

  • Expert
  • 172 Answers

The VLOOKUP and HLOOKUP functions contain an argument called range_lookup that allows you to find an exact match to your lookup value without sorting the lookup table

I have posted below link to know more .Please have a look..

http://www.howtodothings.com/computers-internet/how-to-use-the-vlookup-and-hlookup-functions-in-microsoft-excel
http://support.microsoft.com/kb/181213

http://office.microsoft.com/en-us/excel-help/vlookup-HP005209335.aspx

http://www.timeatlas.com/5_minute_tips/general/learning_vlookup_in_excel

Please rate & vote if you like soution..

Thanks
Sandeep

Posted on Mar 14, 2011

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    Superstar:

    An expert that got 20 achievements.

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

  • Master
  • 10,421 Answers

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

This is a Kitchenaid KSRS22FGBL00 - The freezer works good with a temp of -20c but the fridge side is not cold & has a temp of 8c. There is no frost build up anywhere. The air vents are not blocked. ...


Hello hlook,

I understand that you are having a problem with your side-by-side refrigerator. The Frezzer is staying closed and the fridge is not getting the air flow from the freezer in order to stay cold. The only possibility it can be is the fan. The fan may be turning but not at the rpms needed to move the air in to the fridge. As I have looked at the air flow chart for your fridge that is the only outcome I can come up with. CLICK HERE to view the air flow chart for your firdge.

With the cover off of the fan try and judge how much air is being moved by the fan. It should have pretty good air flow like the low setting on a box fan. You should be able to fell the air flow from two to three feet away.

Thank you for choosing FixYa.com

Justin

May 03, 2011 | Refrigerators

1 Answer

I am not able to get all the formulas that are to be used in Companies..How can we use?...I want to get about the procedure for Vlook also?


Most companies do up their own formulas, using a spreadsheet program. After they get the results they are looking for, they either remove any guidelines or copy & paste the parts they want into a word processor document.

Jan 13, 2009 | Computers & Internet

1 Answer

How do I say look at cell on left rather than the cell number


vlookup can only locate values within the lookup range and to the right of the lookup column. to address your concern, i'd advise you to create a dummy column within the lookup range (and hide it) and link it to the lookup column. this way, we won't need a (-) column index number.

Oct 31, 2008 | Microsoft Excel for PC

1 Answer

Doubt about excel


My dear user,

Vlook up is asoftware tool in built used to look data simultaneously at a time. However, the situation depends on the data you enter- and look up.For example, if you enter a drug name " cough-act" you can have a look at it by just typing key word only with alphabet.

Sep 12, 2008 | Microsoft Computers & Internet

2 Answers

EXCEL VLOOK Function


Just noticed a small syntax problem, try this:
VLOOKUP(S9,$S$14:$T$18,2,0)

I always add the last parameter of "0" to insure that that an exact match is found.

Jul 27, 2008 | Computers & Internet

1 Answer

Vlookup


You know, you really should have said it's an Excel problem, because it is; also your invoice and receipt numbers should probably be 10-12 digits long (yes, even if you do a mere 20 deals a year).

Add error checks and alerts to your spreadsheet, for starters; second, state the version etc. of the spreadsheet program you use, and how much memory is available on your system. VLookup often bombed or just gave the last result forever if it didn't have 130MB to play with. Other times it behaved if you ran certain initializations for it....

Mar 23, 2008 | Computers & Internet

3 Answers

Vlookup


how do you use the vlookup

Jan 17, 2008 | Microsoft Excel for PC

Not finding what you are looking for?
Microsoft Excel for PC Logo

200 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2658 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18389 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...