Excel - Vlookup or Index Match with various criteria

0
votes

I'm trying to fill in values under the "QTY" column of the Target sheet 2 (COL D), BY LOOKINGUP the values from the source sheet 1 (img 1). The quantities need to be referenced by 'Material' and 'Size'.

Img 1: Source Sheet 1 with Quantities corresponding to Sizes (highlighted in Yellow) Source Tab with Quantities Against Sizes

Img 2: Target sheet 2 where I have to enter the Quantity values

enter image description here

Any help on the formula would be appreciated

1
excelvlookup

1 Answers

3
votes

enter image description here

Never, ever use VLOOKUP for anything. Ever.

=INDEX($B$2:$E$5,
MATCH(H5,$A$2:$A$5,0),
MATCH(I5,$B$1:$E$1,0))