![]() ![]() 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. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |