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.
![How To Apply VLOOKUP and XLOOKUP Formula on Large Data in Excel [Hindi] #excel](http://i.ytimg.com/vi/gAY9is-ahQY/mqdefault.jpg)
Wow, I am deeply impressed. Great tutorial, very well explained
Excellent class, buddy! Congrats!
Excellent, very helpful Sir. Thanks.✌
Thank you, that really helped me optimize my sheet and make it faster!
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.
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.
Thank you, this was very helpful
Super Bro❤❤❤
How about if I don’t want to specific range manually like A2:last row
Is there a way to bring in multiple rows of data with this example ?
Hey bringing in multiple rows of data sounds like an 'import' function. You can look into 'importrange' and define which range to import.
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?? 😀
very good video.
Glad you liked it!
Is it possible for you to give some example sheets which I would be able to copy and practice? 🙏
Best of luck with your Google Sheets Channel 😃 #SkyBaum
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
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.
How to clean up N/As?
New sub here
Welcome aboard!
Impressive
Great
This works only in Google sheet, you should have mentioned that clearly