Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HLOOKUP() explanation
Hello All,
Could someone explain what the last 2 and the 0 characters in the function actually mean ( or achieve ) in the following statement =HLOOKUP(c3,d4:h4,2,0) eg. if I replace the 2 with a 1 or a 3 or 4 - all I get is error messages. I would be extremely grateful of a down to earth explanation. Then I will probably be able to achieve more good work knowing the answer. Kind regards |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HLOOKUP() explanation
Hi,
The 2 tells the formula which row from the top to return the value from so as your table has only 1 row anything other than 1 will give a Ref error if a match is found =HLOOKUP(A1,B3:G4,2,FALSE) The above formula has 2 rows so 1 or 2 is valid, The last argument is logical a zero or TRUE returns an approximate match. A 1 or false returns an exact match only. Mike "Finance Guru" wrote: Hello All, Could someone explain what the last 2 and the 0 characters in the function actually mean ( or achieve ) in the following statement =HLOOKUP(c3,d4:h4,2,0) eg. if I replace the 2 with a 1 or a 3 or 4 - all I get is error messages. I would be extremely grateful of a down to earth explanation. Then I will probably be able to achieve more good work knowing the answer. Kind regards |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HLOOKUP() explanation
That formula can't work. It tries to extract data from the second row of a one-row range (that is the 2 in the formula)
I find this is all well explained in Excel Help. Here's a tutorial about VLOOKUP(). Apart from the orientation of the lookup table (vertical instead of horizontal) it is essentially the same. http://www.contextures.com/xlFunctions02.html Post again in this thread if you have specific problems. -- Kind regards, Niek Otten Microsoft MVP - Excel "Finance Guru" wrote in message ... | Hello All, | | Could someone explain what the last 2 and the 0 characters in the function | actually mean ( or achieve ) in the following statement | | =HLOOKUP(c3,d4:h4,2,0) | | eg. if I replace the 2 with a 1 or a 3 or 4 - all I get is error messages. | | I would be extremely grateful of a down to earth explanation. Then I will | probably be able to achieve more good work knowing the answer. | | Kind regards |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HLOOKUP() explanation
Many thanks Mke
I think I have got it now. "Mike H" wrote: Hi, The 2 tells the formula which row from the top to return the value from so as your table has only 1 row anything other than 1 will give a Ref error if a match is found =HLOOKUP(A1,B3:G4,2,FALSE) The above formula has 2 rows so 1 or 2 is valid, The last argument is logical a zero or TRUE returns an approximate match. A 1 or false returns an exact match only. Mike "Finance Guru" wrote: Hello All, Could someone explain what the last 2 and the 0 characters in the function actually mean ( or achieve ) in the following statement =HLOOKUP(c3,d4:h4,2,0) eg. if I replace the 2 with a 1 or a 3 or 4 - all I get is error messages. I would be extremely grateful of a down to earth explanation. Then I will probably be able to achieve more good work knowing the answer. Kind regards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FORMULA EXPLANATION | New Users to Excel | |||
Explanation of when & how to use ( ) { } : ; , ! etc? | New Users to Excel | |||
Formula Explanation Please | Excel Discussion (Misc queries) | |||
A better explanation of help required | Excel Discussion (Misc queries) | |||
Quick Explanation | Excel Worksheet Functions |