| 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 |
| 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 | |||
Threaded Mode
