XLOOKUP to Replace VLOOKUP and HLOOKUP in Excel

Have you ever wished for a function in Excel that outperforms the widely used, indispensable VLOOKUP function? Let me rephrase the question. Have you wished for a function that can do one or more of the following (without workarounds or complex formulas)?

  • Search a range or array and return multiple values
  • Return a specific text of your choice if values are not found
  • Return a value that resides in a column to the left of the lookup column. I.e. location of the column of the returned value does not matter in reference to that of the lookup column.
  • Can search both vertically (VLOOKUP) and horizontally (HLOOKUP). It searches in any direction.

If yes, then your wish has come true with the new function XLOOKUP that is an improved version of VLOOKUP overcoming all limitations mentioned above.

The video shows five scenarios that make you switch to XLOOKUP today.

Comments

No comments yet. Why don’t you start the discussion?

Leave a ReplyCancel reply