Avoid Common XLOOKUP Errors and Issues

This short video shows how to address common XLOOKUP errors and issues. Specifically:
- XLOOKUP returns an error due to data type issues
- Multiple matching rows
- Return the first match
- Return the last match
- Return all matches
- Aggregate all matches

Chapters in this video:
00:00 - Introduction
00:14 - Exercise 1
01:50 - click-start
01:54 - Exercise 2
03:33 - Exercise 3

Also, check out these videos with time saving Excel Hacks:

[harumih.]

The use of "FILTER" function is new to me, which is very helpful going forward, whenever I encounter similar situations.

[shivamkathir]

Thanks for the video. When I try to use the fomula to get values against IP address(Ex., 10.17.100.10, 10.17.101, 10) the output is same. How to get appropriate values?
Could you guide?

[stevereed]

The other issue could be arrays that don't match in size

[SrinivasaRajuVuppalapati]

I am using Office 365 somehow i am getting this error !!! Its not allowing. relative reference in XlookUp

[adnansz]

is there any way to xloop up Invoice 1022 with the ammount 852. this is most likely the problem in real life. lookup the the middle number

[chloeturner]

So helpful, I was asked this question and didn't think of wrapping with the "Value" Function.Thanks Jeff!

[rusektor]

Oh yeah... I used to convert text column to number ))

[marknassi]

Thanks Jeff! I totally got stuck on this exact problem and didn't know the value function would work. Looking up zip codes with an apostrophe in front of it would hopefully work for next time.

[PaulEBrownbill]

Excellent video, thanks, including how to use min and max in combination Paul