Forum Discussion
Solved
TEXTJOIN with and IF and extra VLOOKUP
Hi, I'm trying to figure out if what I'm trying is possible at all or if I should try a different approach. In short my issue: I managed to create a TEXTJOIN formula with an IF that produces id...
You are right, sorry, formula works only on Excel with dynamic arrays. CSE formula on pre-DA Excel doesn't work. It looks like TEXTJOIN as array formula is workable only with nested IF, but I din't dig too deep.
As workaround I'd suggest to add helper column to this your table
adding filename as
=VLOOKUP([@[pictures_id]],pictures,4)When in the main table
it'll be
=TEXTJOIN(", ",TRUE,IF(Tabel3[items_id]=[@id],Tabel3[Filename],""))I checked on semi-annual channel with pre-DA Excel, it works.
SergeiBaklanThanks !
This works now also in my Excel version.
Many thanks again for the quick response.
n-v-l , good, thank you for the update