Introducing The Law Community, the online community just for Clio customers. Sign up now.

How to Cross Reference Excel Spreadsheet Data Using Xlookup

Objective:

  • Compare and combine data on two different spreadsheets.
  • Looking up a value in a column or row, and return a cell from the corresponding row or column

Environment:

  • Microsoft Excel

Additional Information:

Procedure:

  • Syntax: =XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode]) 
  • Input lookup_value, the value you want to look up
  • Input lookup_array, the column or row you want the lookup_value to be found in
  • Input return_array, the column or row you want the corresponding cell to be returned from
  • Optional: Input value if no results found
  • Optional: Specify match type, exact match is by default
  • Optional: Specify the order to search from 
Was this article helpful?
This information is confusing or wrong
This isn't the information that I was looking for
I don't like this functionality