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)

DOWNLOAD WORKSHEET

Print Friendly, PDF & Email

Do you want to excel in Excel?

Or

Seeking Microsoft Certification?

Every Week Receive Resources To Get you Closer to Your Goal!

No Huff! No Fluff! No Spam!

You are on your way to Excelling in Excel and Becoming Microsoft Certified!

Share This

Spread the Good News!

Do me favour, please? Share this with your friends!

Thanks For Commenting!

Awesome for you to comment! Please share the post with your friends.