Dear All,
I created an array formula for multiple index match with "&" . Excel is taking long time to calculate. I want a simple formula instead of array formula
=INDEX(C:C,MATCH(A2&B2,F:F&G:G,0))
Required Quantity in H as per Code ( A) and Group (B)
Bookmarks