Vlookup return multiple columns?

[Gokily]

Do not know is it possible to vlookup to return multiple columns like this (3:00)

Excel - Vlookup Array function

Can index be set to multiple columns? Cannot find any information regarding that,I’ve tried something but it always returns only 1 column.

Thank you

[JohnSUN]

Yes it’s possible.

Make sure you enter an array of column numbers according to these rules.

And don’t forget to finish typing by pressing Ctrl+Shift+Enter (instead simple Enter), so that Calc knows that this is an array formula.

[jimk]

For example, based on the video, enter the following in C3 and press Ctrl+Shift+Enter.

=VLOOKUP(B3;B7:E9;{2,3,4};0)

vlookup with multiple columns.ods