image-4 This is the difference in Xlookup and VLookup. For the most park. Xlookup can lookup values anaywhere, use different matching types, lookup vertically and can return a dynamic array.