my company uses a lot of index matches to sum values between a date range by account... i've been slowly trying to move them over to sumifs. i wonder if sum/xlookup would work even better for this
Potentially, but it depends on the layout of the data. XLOOKUP isn't necessarily a big improvement over SUMIFS, and sometimes it can be confusing if people don't understand that XLOOKUP can also return arrays or ranges of cells.
Hi Brian, I'm Chinmay from EY India. I just love your videos and content. 6 on 5 if I have to rate it. 2 quick questions: (1) which screen recorder or screen pen/writer you use. (2) Also, Index Match beats lookup hollow but I came across a situation where **only vlookup works** (it was a case with indirect - scenario analysis) -- let me know how I can share that with you. And Thanks and keep making awesome videos more frequently :)
1) Camtasia Studio. 2) I don't think there's a scenario where only VLOOKUP works because it's more limited than the other functions discussed here, but feel free to share what you have.
@@financialmodeling Thank you so much for your reply. I have uploaded on my Google Drive and here is the link for you " drive.google.com/file/d/1hHP7nOX5G3Hr-qfPrFnP88iEM6f_W4wS/view?usp=sharing " | There are 3 worksheets in this file. Do let me know your comments. Thank You so much for response and taking out time for your subscribers, really means a lot!
@@financialmodeling Hi Team, did you get a chance to look at the above comment? I know your calendar is hectic, but do let me know if you go through it, Thanks!
@@chinmaya.6934 Sorry, but we cannot review files from individuals. This UA-cam channel is a free resource, and we attempt to answer quick questions when possible, but reviewing files and financial models is outside the scope of what we can do for free here.
![Working Capital and the Change in Working Capital in Valuation and Financial Modeling [REVISED]](http://i.ytimg.com/vi/tMgty8jwmHI/mqdefault.jpg)
Awesome! hope MS brings more user friendly functions like this, and hope Brian keeps exploring and updating those to us.
Thanks for watching!
Great video! Well explained and a good amount of detail.
Thanks for watching!
this is excellent. thank you.
Thanks for watching!
loved it. May I have the Excel file...?
Thanks. You can click "Show More" below the video and then click through to the files to access them.
my company uses a lot of index matches to sum values between a date range by account... i've been slowly trying to move them over to sumifs. i wonder if sum/xlookup would work even better for this
Potentially, but it depends on the layout of the data. XLOOKUP isn't necessarily a big improvement over SUMIFS, and sometimes it can be confusing if people don't understand that XLOOKUP can also return arrays or ranges of cells.
@WhiteCarBlackWheels - try researching on advance or expert level usage of SUMPRODUCT. I think it can be useful in the situation you described
Hi Brian, I'm Chinmay from EY India. I just love your videos and content. 6 on 5 if I have to rate it.
2 quick questions: (1) which screen recorder or screen pen/writer you use.
(2) Also, Index Match beats lookup hollow but I came across a situation where **only vlookup works** (it was a case with indirect - scenario analysis) -- let me know how I can share that with you. And Thanks and keep making awesome videos more frequently :)
1) Camtasia Studio. 2) I don't think there's a scenario where only VLOOKUP works because it's more limited than the other functions discussed here, but feel free to share what you have.
@@financialmodeling Thank you so much for your reply. I have uploaded on my Google Drive and here is the link for you
" drive.google.com/file/d/1hHP7nOX5G3Hr-qfPrFnP88iEM6f_W4wS/view?usp=sharing " | There are 3 worksheets in this file. Do let me know your comments. Thank You so much for response and taking out time for your subscribers, really means a lot!
@@financialmodeling Hi Team, did you get a chance to look at the above comment? I know your calendar is hectic, but do let me know if you go through it, Thanks!
@@chinmaya.6934 Sorry, but we cannot review files from individuals. This UA-cam channel is a free resource, and we attempt to answer quick questions when possible, but reviewing files and financial models is outside the scope of what we can do for free here.
@@financialmodeling I can understand. No worries