=SUMIF(range, criteria, [sum_range])

=INDEX(lookup_array, MATCH(lookup_value, lookup_array, 0))

=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

=HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])

To search for a value in a table and return a corresponding value from another column.

To insert a new row in the spreadsheet

To change the font style of a cell

To calculate the sum of a range of cells

lookup_value, table_array, row_index_num, and range_lookup

search_value, data_array, col_index_num, and exact_match

value_to_find, array_to_search, index_num, and approximate_match

lookup_value, table_array, col_index_num, and range_lookup

It searches for a value in the rightmost column of a table.

It searches for a value in the middle column of a table.

It searches for a value in the leftmost column of a table.

It searches for a value in all columns of a table.

Lookup value becomes zero

#N/A or #VALUE!

Table explodes

Error 404

No

Only if the columns are adjacent

Yes, but only in specific versions of Excel

Yes, always

Vlookup looks up a value in the horizontal direction

Hlookup looks up a value in the vertical direction

Vlookup looks up a value in the diagonal direction

Vlookup looks up a value in the vertical direction, while Hlookup looks up a value in the horizontal direction.

Specify the worksheet name followed by an exclamation mark (!) before the table array reference

Enter the data manually from the other worksheet

Use the SUM function to retrieve data

Use the AVERAGE function to retrieve data

Double-checking the table array, using relative cell references, and ensuring the exact match option is selected.

Forgetting to input the lookup value

Using absolute cell references

Not specifying the exact match option