Master Your Spreadsheets

Tutorials, tips, and formulas for Excel, Google Sheets, and general productivity. Simplified for everyone.

Recent Tutorials

April 15, 2024Excel

Learn the basics of VLOOKUP to find data in your spreadsheets efficiently.

April 12, 2024Google Sheets

The QUERY function is powerful. Here is how to get started.

April 10, 2024Productivity

Boost your efficiency with these simple yet effective tips.

Standard VLOOKUP Syntax

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

Simple Logic

=IF(logical_test, value_if_true, value_if_false)