Excel - VLOOKUP, Return Multiple Columns, Advanced Lookups

Learn how to get VLOOKUP to return multiple columns in Microsoft Excel. This tutorial covers advanced lookup techniques using arrays & VLOOKUP, MATCH, SEQUENCE functions.

#excel #vlookup

[damadgracer]

I needed to use vlookup to return data from another worksheet but that worksheet had 88 columns. You just SAVED me from typing in the formula for those columns! Thank you!

[Shoobedooby]

Life saver. Thank you so much for showing the formula for older excel versions as well, very helpful.

[AndieG.-buxf]

Gave me what I needed and more! Thank you so much!!

[philtrelatsky]

Thank you for this. Was the only video that helped me achieve what I was looking for.

[MilesOnBikePK]

Thank you so much Sir, I was trying from last 3 hours and at last watched your video and my issue solved. Thanks.

[mikeisgettinupset]

Thank you so much for this! I was spinning my wheels trying to do it with a pivot table, and with your guide i had what i was trying to do, done in like 2 minutes!

[nctotal]

You are awesome! 2 mins into your video, I was on track!

[musicwithdummy]

This was the easiest to learn, thanks a lot simple is the best, before this I checked out many videos they all explained but using complex methods which I couldn't understand. Thanks a lot, this tutorial worked.

[simon]

thanks so much for sharing this! exactly what i need!

[Isaiye]

Great and simple video ! Thanks for clear explanation

[esrAsnataS]

Perfect! Exactly what I was after, thank you very much!!!

[hanhildamanuel]

Thank you so much ....this is wat I was looking for ...you eased my work thanks a lot

[ganeshsasane]

Very nice, was lookign for this since long . Good demo !!

[jesusfollower]

Soooo good, very very helpful. Thanks a ton!

[maestroandoy]

Thanks for this.. The problem is it wont fill up all the cells for #N/A

[stephenlo]

Hello, is there a similar way where one can return rows instead of columns?

[muz]

Are you familiar with skiptraced data? The landline and mobile numbers are mixed in columns. I want to sort 3 columns of phone numbers so all the mobile are in 1 column and landline in a separate column. The phone # and ph type are in separate columns.

[akshayshettyp]

sir
i have Dr & Cr two cloums lookup both colum and result should come one cell either Dr or Cr

[kidszone]

Will this also work in google sheet with same formula

[SB-frts]

need guidance of fetching up using vlookup and columns from different work books.pls guide