|
Klassieke bestandstypen zijn vanaf januari 2021 niet meer beschikbaar voor gebruik. U kunt uw klassieke bestanden omzetten of een PDF downloaden. Meer informatie

Opmerkingen

18 opmerkingen

Datum Stemmen
  • Officiële opmerking
    Mike Davis

    Fantastic news! Not only has XLOOKUP been taken out of purgatory, but it has also been now released to the Workiva Platform for use, along with a slew of other formulas. 🥳
     

    Thanks so much for your patience and feedback along the way. We couldn't have done it without you. And have a happy holiday season!🎄🥂

  • Thomas McKinney

    Hi,

    I strongly support the addition of XLOOKUP to bring Workiva spreadsheets up to date with current Excel functionality. We leverage Workiva spreadsheets extensively to map our financial statements from a trial balance import and have to currently uses outmoded and somewhat cumbersome functions such as index/match to achieve this. XLOOKUP would make this process much more efficient and transparent to the spreadsheet creators and reviewers. 

    Thanks in advance for your consideration,

    1
  • Rebecca Horsley
    • Bewerkt

    Mike Davis I agree with Thomas McKinney; XLOOKUP is a much more comprehensive function than VLOOKUP/HLOOKUP and much more user friendly than INDEXMATCH. Please consider adding XLOOKUP functionality to Workiva.  Thank you! 

    0
  • Mike Davis

    Thanks for sharing your insights Rebecca Horsley 😎

    1
  • Adrienne Ramsay

    Is there any update regarding xlookup functionality being added to Workiva? Mike Davis

    1
  • Mike Davis

    Welcome to the community, Adrienne!

    Sadly, there's not any new updates for XLOOKUP and it remains unplanned. Definitely happy to add your request for it though. Each little bit helps.

    1
  • Jermy Johnson

    Hope XLOOKUP gets added as well. This is an very helpful in Excel as my team uses it a lot and would love to have that capability in Workiva as well. Thumbs up on this request.

    1
  • Jermy Johnson

    That is FANTASTIC news indeed! Good Christmas surprise right here! Looking forward to the full list of new formulas that were added!

     

    Thanks Mike Davis

    0
  • Pedro Andrade

    Great Job! Amazing formula!! It eases a lot the search for data in a specific coordinate!

    0
  • Roman Magar

    Awesome! This was the most awaited formula. Great Work!!!

    0
  • Michael Sanchez

    It's helpful to have the XLOOKUP function and am wondering if like in Excel, Wdesk supports multi-column return_ranges?  In this example, a single formula can return both Name and Dept from the EmpID value.  Wdesk XLOOKUP appears to support only a single column return_range because it generates a "Ranges cannot be displayed in cells" error. Does it support single column ranges only or am I missing something in the formula? 

     

     

    0
  • Mike Davis

    Thanks for sharing, Michael!

    0
  • Karen Cheung

    It would be super helpful if xlookup formula can incorporate multiple look-up criteria. This would help the end user avoid creating a separate col to CONCATENATE formula. Currently, if I were to put this xlookup formula, it would error out.

    https://www.automateexcel.com/formulas/xlookup-if/ 

     

     

    0
  • Andrew McKenzie

    It's great to have XLOOKUP on Workiva. But I agree with Karen Cheung and was even going to post the same thing recently. This would enhance the value of Workiva's XLOOKUP and bring parity with Excel in this regard.

    0
  • Mike Davis

    Thanks much for your added input, Karen and Andrew. We'll be sure to get this info shared and keep you apprised of future developments for sure. 

    0
  • Karen Zhang

    +1 for the multi-column return and multi-lookup criteria features for the XLOOKUP formula. 

    0
  • Wannes

    Any update on the multiple criteria function being released anytime soon?

    0
  • Mike Davis

    Hi Wannes!

    Yes! XLOOKUP supports multiple criteria in Workiva spreadsheets.

    You can combine multiple criteria by concatenating them in both the lookup value and the lookup array using the & operator.
     
    Example formula: 
    =XLOOKUP($A96&$B96, 'Invest TB'!$A$1:$A$1500 & 'Invest TB'!$H$1:$H$1500, 'Invest TB'!$B$1:$B$1500, "")
    Here's how it works:
    • - Lookup value: $A96&$B96 — concatenates the two criteria cells into one combined key
    • - Lookup array: 'Invest TB'!$A$1:$A$1500 & 'Invest TB'!$H$1:$H$1500 — concatenates the two lookup columns to create a matching combined key
    • - Return array: the column you want the result from
    • - If not found: "" — returns blank if no match
     
    A few things to keep in mind:
    • - CHILDREFS is not supported inside XLOOKUP. If you need to look up data across multiple child sheets, explicitly list sheet names in VSTACK instead.
    • - Cross-file formulas are not supported. Use connected sheets as a workaround if data lives in a separate spreadsheet.
    0

U moet u aanmelden om een opmerking te plaatsen.