Forum Discussion
Solved
Multiple lookup values on XLOOKUP formula
Hi all, Hoping that someone can help me. I got 2 tables in Excel; 1 table holds data for incident tickets with columns like reference number, issue type, priority, status, and linked issues - wh...
Hi ydlazkov
Prefix "_xlfn." means a function (in use) isn't found/available to you and the picture you shared shows that you don't have TEXTSPLIT
According to the doc. the function is available on Windows Version 2208 Build 15601 but you're not at that stage yet (Version 2008 Build 13127.21624)
In the meantime you can replace TEXTSPLIT with FILTERXML as follow (sample attached):
=TEXTJOIN(", ",, XLOOKUP( FILTERXML("<t><w>" & SUBSTITUTE(Change[@[Linked Issues]], ";", "</w><w>") & "</w></t>", "//w"), Incident[Key], Incident[Type], "Not found" ) )NB: FILTERXML won't work on Mac and Excel Web/Online
Hi ydlazkov
Assuming I understood (not sure...)
in E3:
=TEXTJOIN(", ",,XLOOKUP(TEXTSPLIT([@[Linked Issues]],";"), ChangeRequests[Key], ChangeRequests[Type], "Not found"))
Hi L z,
Thank for this suggestion however I always got "#NAME?" when the cell under linked issues is empty. Tried using LET function but still got same results. Any idea how to catch this kind of error?
Thank for this suggestion however I always got "#NAME?" when the cell under linked issues is empty. Tried using LET function but still got same results. Any idea how to catch this kind of error?