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.

Have you ever try to pull data from a spreadsheet using a lookup formula with more than one matching condition and don’t know how to get it to work? Then this video is for you, I will show how to create a lookup formula with multiple conditions using Index and Match functions #exceltutorial #exceltips