Add support for XLOOKUP formula
已完成The following enhancement was shared by a Workiva user:
We are really excited for this new formula in Excel and wants to know if we would consider adding it too.
https://techcommunity.microsoft.com/t5/Excel-Blog/Announcing-XLOOKUP/ba-p/811376
If you also would like this feature request, feel free to comment below, vote up the post or share your own awesome idea here.
-
正式评论
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!🎄🥂
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
Mike 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
Thanks for sharing your insights Rebecca Horsley 😎
1
Is there any update regarding xlookup functionality being added to Workiva? Mike
1
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
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
That is FANTASTIC news indeed! Good Christmas surprise right here! Looking forward to the full list of new formulas that were added!
Thanks Mike
0
Great Job! Amazing formula!! It eases a lot the search for data in a specific coordinate!
0
Awesome! This was the most awaited formula. Great Work!!!
0
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
Thanks for sharing, Michael!
0
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
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
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
+1 for the multi-column return and multi-lookup criteria features for the XLOOKUP formula.
0请先登录再写评论。
评论
16 条评论