[Solution] GoSkills Excel Challenge 37 - February 2024: Keeping Track of Inventory

Were you able to create that dynamic stock inventory database? The solution to GoSkills Excel Challenge 37 is here! 🪄
📌 PS. If you haven't taken the challenge yet, it's never too late to do so. Download the worksheet to get started and come back to this video to compare solutions: www.goskills.com/Excel/Resour...
------------------------------
There are multiple ways to solve this challenge. The one in the video is just one! We'd like to know your approach. You can leave a comment below or upload your solution and discuss it in our Excel Slack community: goskills.typeform.com/to/h0GB...
------------------------------
We release a new Excel challenge every month. Make sure to subscribe to our channel to get notified once the next challenge is released: / @goskillscourses
------------------------------
These skills and more are covered in our highly popular course: www.goskills.com/Course/Excel...
We have a 7-day free trial waiting for you! 🎁
#MicrosoftExcel #Excel #ExcelChallenge #ExcelFunctions #Inventory #InventoryManagement #DataAnalysis #ExcelTipsAndTricks #LearnExcel #ExcelTraining
------------------------------
For more Excel and career-boosting updates, follow us on socials:
☑️ LinkedIn: / go-skills
☑️ Facebook: / goskills
☑️ Instagram: / goskills
☑️ Twitter: / getgoskills
Or visit our website: www.goskills.com/?...

[@aijazali8926]

Thank you for this useful exercise!

[@SB-tw9cz]

Thank you very much. Although I don’t know English well, I have benefited greatly from what you provide. Many thanks to you, madam.” 🌟

[@GoSkillsCourses]

That's amazing to hear! We're happy to know this has been helpful to you!

[@bij20]

Thanks for this, Deborah.
I think using INDEX MATCH with the -1 'match type' operator to look up the status of the stock from the table provided is marginally simpler than using the IFS function (only requires you to reference two arrays, rather than 6 individual cells).
Otherwise I used the same approach -- FILTER is such a powerful formula, thanks for highlighting that so clearly in this exercise!

[@stephanebarret2517]

Hi Deborah,
thanks for the video.
I am not sure that IFS is shorter tan two nested IF (actually, I think that it is the opposite but that's not really important 😁)

[@GoSkillsCourses]

@stephanebarret2517 I think you're right!🤣

[@omerkaygisiz7293]

Thank you. How would be the last formula if we dont use filter function?

[@GoSkillsCourses]

Hi @omerkaygisiz7293, actually one of our community members shared their method of doing that. It involves a combination of INDEX, SMALL, and ROW functions, with IFERROR to suppress errors. It looks something like this: =IFERROR(INDEX(H4:K204,SMALL(IF(L4:L204=B5,ROW(L4:L204)-ROW(L4)+1),ROW(L4:L204)-ROW(L4)+1),{1,2,3,4}),"")
The link for our Slack group is: join.slack.com/t/goskills-excel/shared_invite/zt-1dugm5d5v-CJohL9qmuoCiHU5x3pkwnQ. Hope to see you there!