MS Excel: How to lookup a combined value using Xlookup and Concat

In this video i will show you a solution that work out for a user request. The user was trying to use a vlookup formula to pull status and qty for a combination of 3 different factors from a datasheet but did not work.