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
XLookUp Vs. VLookUp
-
- Administrator
- Posts: 80041
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: XLookUp Vs. VLookUp
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.
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
Hans
-
- BronzeLounger
- Posts: 1506
- Joined: 01 Mar 2015, 02:03
Re: XLookUp Vs. VLookUp
Hello Hans,
Thanks for your response.
BittenApple
Thanks for your response.
BittenApple