How to return multiple rows in VLOOKUP?
This video helps you understand how to return multiple values using VLOOKUP Function. It allows you to return the values for a whole column in a single formula or even return values of multiple columns.
ARRAYFORMULA can be a life saver when dealing with big datasets and help improve the quality of your data, as well as lighten the sheet size without overloading it with multiple formulas doing the same job.
Such quick automation tricks can help you save a lot of time.
Пікірлер: 32
Thank you, this was very helpful
Wow, I am deeply impressed. Great tutorial, very well explained
Very well put together. Simple but effective.
Excellent class, buddy! Congrats!
Thank you, that really helped me optimize my sheet and make it faster!
Excellent, very helpful Sir. Thanks.✌
Best of luck with your Google Sheets Channel 😃 #SkyBaum
Super Bro❤❤❤
very good video.
@KhanAtWork
2 жыл бұрын
Glad you liked it!
Hi sheetHacker :) Thank you so much for your video. I have some questions for you.
Is it possible for you to give some example sheets which I would be able to copy and practice? 🙏
Impressive
How about if I don’t want to specific range manually like A2:last row
Great
Please zoom the video so that it will clear visible.
@KhanAtWork
Жыл бұрын
Thanks @soumensaha4426 yes these are some old videos I will be releasing better quality videos soon.
what is the formula if do the entry in general sheet and it automatically gets to it sub sheet so i doesnt have to re enter into its sub sheet
@KhanAtWork
Ай бұрын
The formula is called Import range This way all entries from a single file can be imported into multiple files. Live.
New sub here
@KhanAtWork
Жыл бұрын
Welcome aboard!
is there a way to do this without creating a similar table? like if i wanted to look at the historical price of an item and how it progressed but all i have is market data
@KhanAtWork
Ай бұрын
I think I need more context. The biggest factor here is how your market data is arranged. If the historical data and it's respective date is available. Then sure why not. You need to change how you build your key and you'll have it.
How to clean up N/As?
We can use vlookup with choose function also right ?
@KhanAtWork
Жыл бұрын
Hey @zealgor2506, I haven't tried that yet, maybe show us how you see it working in the same use case?? 😀
what is the equivalent of Arrayformula in Excel?
@jeevan1109
4 ай бұрын
No need really, the Normal VLOOKUP will do the trick. Just enter allthe return columns within the curly brackets as shown.
I'm using the letest 2021 version but arraformula is not showing, instead of this "arraytotext" is showing. Can you guide me what to do
@KhanAtWork
Жыл бұрын
Hey @elipantocorvanto9512 this works for Google Sheets, I believe you're talking about a 2021 version on MS Excel. Right?
@crazytubes2249
11 ай бұрын
Yes, its arrayformula is not available in MS Excel version any alternative for this?@@KhanAtWork