Announcement

Collapse
No announcement yet.

XLOOKUP to replace VLOOKUP and INDEX?MATCH

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • XLOOKUP to replace VLOOKUP and INDEX?MATCH



    August 28th 2019, Microsoft announced a new function called XLOOKUP that iimproves VLOOKUP.

    Note: August 28, 2019: XLOOKUP is currently a beta feature, and only available to a portion of Office Insiders at this time. We'll continue to optimise it over the next several months. When XLOOKUP is ready, we'll release it to all Office Insiders, and Office 365 subscribers.
    Use the XLOOKUP function when you need to find things in a table or a range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID. With XLOOKUP, you can look in one column for a search term, and return a result from the same row in another column, regardless of which side the return column is on.
    Hope that Helps

    Roy

    New users should read the Forum Rules before posting

    For free Excel tools & articles visit my web site

    RoyUK's Web Site

    royUK's Database Form

    Where to paste code from the Forum

    About me.
Working...
X