![]() The third parameter is the position number in the table where the return data can be found. The HLOOKUP uses the first row in this range (ie: A1:G1) to search for the value of 10251. In this example, the second parameter is A1:G3. ![]() The second parameter in the HLOOKUP function is the table or source of data where the horizontal lookup should be performed. This is the value that the HLOOKUP will search for in the first row of the table of data. In this example, the first parameter is 10251. The first parameter in the HLOOKUP function is the value to search for in the table of data. Now, let's look at the example =HLOOKUP(10251, A1:G3, 2, FALSE) that returns a value of $16.80 and take a closer look why. ![]() Result: $14.00 'Returns an approximate match Result: #N/A 'Returns #N/A error (no exact match) Let's explore how to use the HLOOKUP function as a worksheet function in Microsoft Excel:īased on the Excel spreadsheet above, the following HLOOKUP examples would return: =HLOOKUP(10251, A1:G3, 2, FALSE)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |