How to return multiple rows in VLOOKUP?
ฝัง
- เผยแพร่เมื่อ 18 ก.ย. 2024
- 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.
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.✌
Thank you, this was very helpful
very good video.
Glad you liked it!
Super Bro❤❤❤
Best of luck with your Google Sheets Channel 😃 #SkyBaum
Impressive
Great
How about if I don’t want to specific range manually like A2:last row
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
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.
what is the equivalent of Arrayformula in Excel?
No need really, the Normal VLOOKUP will do the trick. Just enter allthe return columns within the curly brackets as shown.
Please zoom the video so that it will clear visible.
Thanks @soumensaha4426 yes these are some old videos I will be releasing better quality videos soon.
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? 🙏
This works only in Google sheet, you should have mentioned that clearly
New sub here
Welcome aboard!
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
The formula is called Import range
This way all entries from a single file can be imported into multiple files. Live.
We can use vlookup with choose function also right ?
Hey @zealgor2506, I haven't tried that yet, maybe show us how you see it working in the same use case?? 😀
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
Hey @elipantocorvanto9512 this works for Google Sheets, I believe you're talking about a 2021 version on MS Excel. Right?
Yes, its arrayformula is not available in MS Excel version any alternative for this?@@KhanAtWork
How to clean up N/As?