Ask Your Question

Joining the results of a LOOKUP or VLOOKUP

asked 2016-12-27 16:37:57 +0100

Barrier gravatar image

How can one join/concat the values of a VLOOKUP?

I have tried =CONCAT(VLOOKUP()) and =TEXTJOIN(VLOOKUP), but they only produce a single result.

edit retag flag offensive close merge delete


Your VLOOKUP() surely must be more detailed. Please don't suppress useful information.
I suppose you needed array evaluation to get a result by VLOOKUP you can pass in a useful way to CONCAT or to TEXTJOIN.
{=VLOOKUP(A1:A5;B1:D20;3;0)} would retur an array, e.g, if some content of a cell in A1:A5 finds a match in B1:B20 ...
Please note that the present implementation of CONCAT and of TEXTJOIN is buggy in a sense. Come back with further questions and supply more details.

Lupp gravatar imageLupp ( 2017-02-12 20:59:17 +0100 )edit

2 Answers

Sort by » oldest newest most voted

answered 2017-02-12 19:24:18 +0100

donedwards gravatar image

In Calc, VLOOKUP only returns one value. Sounds like you want something similar that returns multiple values; I'm pretty sure there is no such built-in function.

If you're into writing macros, it wouldn't be difficult to write a custom function that does what you're asking for here.

edit flag offensive delete link more

answered 2017-02-12 21:18:47 +0100

Lupp gravatar image

Just made this little demo.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-12-27 16:37:57 +0100

Seen: 147 times

Last updated: Feb 12 '17