VLOOKUP

Discover how to use Excel’s VLOOKUP function with clear, step-by-step guides. Explore easy examples, helpful tips, and practical solutions to quickly find data in your spreadsheets. Save time and reduce mistakes by mastering this essential Excel tool.

VLOOKUP NA error cover

Why VLOOKUP Returns #N/A Error

Discover why the VLOOKUP function returns an #N/A error in Excel. Learn the common causes and how to quickly fix VLOOKUP errors.

Search in 2 Columns with VLOOKUP & XLOOKUP

How do you search in 2 columns in Excel? Why Search Two Columns? When working with dates and currencies, each date has different values for each currency. The currency code repeats daily. To get accurate results, we must build a unique identifier by combining the Date and Currency columns. VLOOKUP Isn't Ideal VLOOKUP only searches in the first column 😡. This is how the function has been developed. Now, if you need to search in 2 columns, you must transform the table and concatenate the two columns to create a new column. After that, you create your VLOOKUP function by using the column as the first column of your reference table. XLOOKUP Is Better If you work with Excel 365, Excel Online, and Excel 2021, it's better to use the XLOOKUP function. This function has been developed to remove the limitations of VLOOKUP. This includes performing a search in two […]
XLOOKUP function cover

Master XLOOKUP function in Excel

Learn how the XLOOKUP function in Excel 365 simplifies data lookup in tables. Find out how it improves VLOOKUP and handles errors better.
Lookup with offset

Create a Lookup Offset

When you have many times the same ID in your table, the following formula will help you to create a lookup offset.
Anonymous Data 9

Anonymize your data

Discover how you can transform your worksheet to anonymise your data in the case you have sensitive data. 5 steps are needed

Categories

Microsoft MVP 2024

VLOOKUP