Discussion Forum | Board Infinity

What are HLOOKUP and VLOOKUP in excel?

HLOOKUP and VLOOKUP

VLOOKUP is an Excel function to look up data in a table organized vertically. VLOOKUP supports approximate and exact matching, and wildcards (* ?) for partial matches. Lookup values must appear in the first column of the table passed into VLOOKUP.
REF:https://exceljet.net/excel-functions/excel-vlookup-function
HLOOKUP is an Excel function to lookup and retrieve data from a specific row in table. The “H” in HLOOKUP stands for “horizontal”, where lookup values appear in the first row of the table, moving horizontally to the right. HLOOKUP supports approximate and exact matching, and wildcards (* ?) for finding partial matches.
REF:https://exceljet.net/excel-functions/excel-hlookup-function#:~:text=HLOOKUP%20is%20an%20Excel%20function,%3F)%20for%20finding%20partial%20matches.

1 Like