HLOOKUP IN MS EXCEL

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

Hi Dear, there are several solutions

• In ms excel type a fraction formula and in tools--> formula auditing -->
• Please download offcemath.msi for MS Word 2007 from www.office.microsoft.com and install it.
  its calculator part will show you the steps of solving fractions in insert--> equations-->maths.
• Alternatively you can download microsoft math trial from www.microsoft.com this will show you all steps.

Zulfikar Ali
[email protected]
9899780221

The value of C7cannot be found in the range - Hence the error.

Select a blank cell in workbook. Click the function icon located informula bar("fx"). In the popup Insertwindow Select category as ALL.Select the function you want to get help and click on "help on this function " located in the left down page. You can get all the formula help bu using this method.  

www.google.com

1024x768 Normal 0 false false false /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} These are Excel functions for Lookup tables. The purpose of Lookup tables is to bring a value to the table, find the closest (or exact) match, and then return another value.

An example is the federal income tax table. On your tax return you get your gross income and number of dependents, go to the Lookup table, and find your taxable income.

The V in VLOOKUP means that the table is vertical; HLOOKUP has a horizontal orientation.

If you use the Insert Function button in Excel and paste either function, the dialog box will explain each required field separately with examples.

HLOOKUP is an excel function to lookup the horizontal row value you specify.

Hi vrusha,

Your right hlookup is very simular to vlookup, the key difference is it searches along the top row of the table, finds the matching data and gives you one of the below cells (depending on how you write the formula), just think of a vlookup on it's side.

The formula works like this:
=HLOOKUP(lookup value, table, row_index_number, range_lookup)

lookup value = is the value you want to match against the table i.e. ABBA

table = the range of cells that make up the table you want to search i.e. A1:D300

row_index_number = the number of rows from the top of the table you want to get the value from, 1 is the top of the table, 2 is directly below

range_lookup = if you want an exact match type FALSE, if you want the nearest match type TRUE

Dear Thccsl, if you meant formulas by writing codings then you can find a complete list of formulas by clicking fx button beside the formula bar in MS excel. You can get complete range of forumlas and example and explanation of how to use this formula.

You also might like to see this for detailed information:

http://en.wikipedia.org/wiki/MS_excel

If this solution was helpful please press solved.

1. formula