By default, VLOOKUP is set to return a Single column but with a small tweak, it can return multiple columns.
=VLOOKUP(G2,B2:E24,{3,4},FALSE)
The only trick is to put the multiple columns in curly braces.
NB:
You can insert the column numbers in any order.
For example, if you want to return the Sales (column 2) and Region (Column 4) in that order then use the below formula
=VLOOKUP(G2,B2:E24,{4,2},FALSE)
Very usefull!
I use:
=VLOOKUP(G2;B2:E24;{4\2};FALSE) – for result in row;
=VLOOKUP(G2;B2:E24;{4;2};FALSE) – for result in column.
Thanks for sharing
Amazing trick and it was very very helpful!!
Glad you found it useful