XLookUp Vs. VLookUp

BittenApple
BronzeLounger
Posts: 1506
Joined: 01 Mar 2015, 02:03

XLookUp Vs. VLookUp

Post by BittenApple »

Hello all,

Team, what do you think about XLookUp? Can it be replaced with VLookUp? Does it return correct results?

Please advise me.

Regards,

Bitten Apple

User avatar
HansV
Administrator
Posts: 80041
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: XLookUp Vs. VLookUp

Post by HansV »

XLOOKUP is a relatively new function. It is much more powerful than VLOOKUP.
Everything that you can do with VLOOKUP, you can do with XLOOKUP too. But there are things that you can do with XLOOKUP that are not possible with VLOOKUP.
And yes, XLOOKUP returns correct results.
Best wishes,
Hans

BittenApple
BronzeLounger
Posts: 1506
Joined: 01 Mar 2015, 02:03

Re: XLookUp Vs. VLookUp

Post by BittenApple »

Hello Hans,

Thanks for your response.

BittenApple