All Courses
AI Career Planner
1:1 Coaching/Mentoring
Job Board
SQL
HTML/CSS/JS
Coding
Settings
LogoutHLOOKUP 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