Excel 365 LOOKUP Functions: Easy Excel 365 Essentials, #6

ALSO BY M.L. HUMPHREY

Listing of all books by M.L. Humphrey

Excel 365 Essentials

Excel 365 for Beginners

Intermediate Excel 365

102 Useful Excel 365 Functions

Easy Excel 365 Essentials

Formatting

Conditional Formatting

Charts

Pivot Tables

The IF Functions

LOOKUP Functions

EXCEL 365 LOOKUP FUNCTIONS

EASY EXCEL 365 ESSENTIALS - BOOK 6

M.L. HUMPHREY

CONTENTS

Introduction

The XLOOKUP, VLOOKUP, and HLOOKUP Functions

Appendix: Basic Terminology Recap

About the Author

Copyright

INTRODUCTION

This book is part of the Easy Excel 365 Essentials series of titles. These are targeted titles that are excerpted from the main Excel 365 Essentials series and are focused on one specific topic.

If you want a more general introduction to Excel, then you should check out the Excel 365 Essentials titles instead. In this case, 102 Useful Excel 365 Functions which covers the various LOOKUP functions as well as a number of other functions.

But if all you want is a book that covers this specific topic, then let’s continue with a discussion of how to use VLOOKUP, HLOOKUP, and the new and incredibly useful XLOOKUP.

THE XLOOKUP, VLOOKUP, AND HLOOKUP FUNCTIONS

Notation:

XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])

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

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

Excel Definition:

XLOOKUP: Searches a range or an array for a match and returns the corresponding item from a second range or array. By default, an exact match is used.

VLOOKUP: Looks for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify. By default, the table must be sorted in an ascending order.

HLOOKUP: Looks up a value in the top row of a table or array of values and returns the value in the same column from a row