Can VLOOKUP Return Multiple Columns? 🤔 By default, NO! 😢 But with a very small tweak...YES!!! Just put the column numbers in curly braces =VLOOKUP(G2,B2:E24,{3,4},FALSE) #exceltips #exceltricks #CheatSheet #programming #spreadsheets

Alternatively, you can use VLOOKUP and MATCH =VLOOKUP(G2, sales, MATCH(H1:I1,sales[ hashtag#Headers ]),0)

To access the worksheet, see below link

Will it work in 2010 excel

Yes, it will. Just remember to Ctrl + Shift + Enter

Working nicely.. thank you...

@DownloadVideo_

It's tricky mate... Working fine..

Happy to help. Once you know the trick...everything looks easy

@SaveMyVideo

Not working

If you do not have office365 You must first highlight the columns Then go to the formula bar Write the formula Finally press Ctrl + Shift +Enter

@SaveToNotion #Thread #Data

Beautiful 🥰

Glad you found it helpful

@SaveToNotion #thread #excel

@readwise save excel

@GetVideoBot