Question about Microsoft Excel for PC

1 Answer

Hello i want to use h LOOK UP - Microsoft Excel for PC

Posted by on

Ad

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that gotĀ 5 achievements.

    Novelist:

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

    Governor:

    An expert whose answer gotĀ voted for 20 times.

  • Expert
  • 93 Answers

Hi !!

How to implement Hlookup function:

  • Select your data and sort it in ascending order
  • Then type '=HLOOKUP(lookup_value,table_array,row_index_num,range_lookup)'.
    Lookup_value is the value to be found in the first row of the table. Lookup_value can be a value, a reference, or a text string. Table_array is a table of information in which data is looked up. Use a reference to a range or a range name. The values in the first row of table_array can be text, numbers, or logical values. If range_lookup is TRUE, the values in the first row of table_array must be placed in ascending order: ...-2, -1, 0, 1, 2,... , A-Z, FALSE, TRUE; otherwise, HLOOKUP may not give the correct value.
    If range_lookup is FALSE, table_array does not need to be sorted. Uppercase and lowercase text are equivalent. You can put values in ascending order, left to right, by selecting the values and then clicking Sort on the Data menu. Click Options in the sort dialog box, click Sort left to right, and then click OK. Under Sort by, click the row in the list, and then click Ascending.
    Row_index_num is the row number in table_array from which the matching value will be returned. A row_index_num of 1 returns the first row value in table_array, a row_index_num of 2 returns the second row value in table_array, and so on. If row_index_num is less than 1, HLOOKUP returns the #VALUE! error value; if row_index_num is greater than the number of rows on table_array, HLOOKUP returns the #REF! error value.
    Range_lookup is a logical value that specifies whether you want HLOOKUP to find an exact match or an approximate match. If TRUE or omitted, an approximate match is returned. In other words, if an exact match is not found, the next largest value that is less than lookup_value is returned. If FALSE, HLOOKUP will find an exact match. If one is not found, the error value #N/A is returned.
  • If HLOOKUP can't find lookup_value, and range_lookup is TRUE, it uses the largest value that is less than lookup_value.
  • If lookup_value is smaller than the smallest value in the first row of table_array, HLOOKUP returns the #N/A error value.
  • If range_lookup is FALSE and lookup_value is text, you can use the wildcard characters, question mark (?) and asterisk (*), in lookup_value. A question mark matches any single character; an asterisk matches any sequence of characters. If you want to find an actual question mark or asterisk, type a tilde (~) before the character.
  • In the example in the Excel training video the sorted data represents the density of water at different temperatures. The left most column gives the temperature in degrees and the top column specifies the 'decimal' degrees
  • We looked up the density of water at 5.4 degrees celsius using the Hlookupfunction.


Still have problems, Check this video on the you tube.



Hope this would help,

Thanks,
Anurag Shukla



Posted on Sep 04, 2009

Ad

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

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

Tip

HELLO TUNE TRICK FOR AIRTEL( legal)


<b>hi Guys...<br />im 1st tym posting mah Trick Which im using from Last 2 months...<br />THIS TRICK HELPFUL FOR THOSE WHO MAINTAIN LOW BALANCE ON PHONE (LESS THAN 10/-)<br /><br />WITH THE HELP OF THIS TRICK U CAN USE HELLO TUNE FOR 10 DAYS @RS 5 ONLY...<br /><br />Now trick is here...<br />.<br />Keep balance app. To zero.. keep balance rs 1 or less than 2...<br />Now call 578785 (toll free) and acticate ur Favorite Hello Tune...<br />after activating.. Ur balance goes to minus 5 (-5)..<br />Dats it...<br />UR HELLO TUNE WILL BE ACTIVATE FOR 10 DAYS... (15 + 10 for just 5 rs.)<br />NOW RECHARGE.. Airtel wont charge u anything later...<br />..<br />.<br />now when ur 10 days are going to over Reduce ur Balance to 1 or less Than 2..<br />Keep ur balance low untill Ur Hello Tune subrcription renew..<br />After 10 days airtel again do ur balance to -5 and renew ur hello tune for 10 days...<br /><br /><img src="smile.gif" /><br />Thats the 100% legal trick.. Working 100% in delhi...<br />Im using it for last 2 months...<br />Enjoy...<br />And reply if its working in ur state or not.??<br />Hit thanx for my work...</b>

on Jan 29, 2011 | Cell Phones

2 Answers

Can you give a sample running C# program?


// Hello1.cs public class Hello1 { public static void Main() { System.Console.WriteLine("Hello, World!"); } }

Mar 01, 2011 | Computers & Internet

1 Answer

I lost my instruction manual for my Hello Kitty


Here is the instructions for the hello kitty popcorn maker

http://www.spectraintl.com/hk/pdf/KT5230E%20English_French%20UM%20%28France%29.pdf

Jan 11, 2010 | Spectra KT5230 Hello Kitty Popcorn Maker

1 Answer

Recorder will not do anything only hello hello. I have unplugged for 10 seconds or more and still nothing happens


recorder will not do anything only hello hello. I have unplugged for 10 seconds or more and still nothing happens

Nov 16, 2009 | RCA DRC8335

1 Answer

How do I get to at least watch a DVD or VCR


if after the hello display you open the tray and inserted already the dvd push play and the thing is always with the hello and after reasonable time (one minute) and nothing change the display stil with the hello thing:
use another dvd and the same answer.
your dvd is not read in the memory because the set is not able to do it and the memory is waiting for that data. So your Dvd memory is waiting for the mechanism to send that data and say: hello.
So time to visit a repair place. to amke sure about any estimate.

Apr 24, 2009 | RCA DRC8335

2 Answers

Hello


hello. well, your hello is not a problem. if you have any contact me. by

Dec 01, 2008 | Adobe Acrobat 6.0 Professional for PC

Not finding what you are looking for?

Open Questions:

See all Microsoft Excel for PC Questions

Microsoft Excel for PC Logo

134 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2854 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18402 Answers

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

Answer questions

Manuals & User Guides

Loading...