VLOOKUP finds values in spreadsheet tables using column headings. Function syntax includes search_value, lookup_table, column_number, and approximate_match. Search_value must be in first column of lookup_table
VLOOKUP is an Excel function for finding values in tables by row. Formula format: =VLOOKUP(lookup_value, search_range, column_number, match type). Used by financial staff for price lookup and employee name finding
IFERROR function can replace standard #N/A errors with custom text. Blank cell or zero can be returned when lookup value not found. IFERROR catches all errors, not just #N/A
VLOOKUP uses column numbers, XLOOKUP uses array syntax. VLOOKUP searches leftmost column, XLOOKUP can search any column. VLOOKUP defaults to approximate match, XLOOKUP defaults to exact match. VLOOKUP can only return one value, XLOOKUP can return multiple
Rows can be merged by pasting data below target table. Columns can be merged by pasting data to right of target table. Merging rows is simple, merging columns can be tricky
IFERROR checks for errors and returns a different value if they occur. ISERROR determines if an expression returns an error. IF ISERROR handles errors and returns a different value if they occur. IF ISERROR VLOOKUP handles errors in VLOOKUP searches