CODEWITHSUNDEEP
excelvlookup
fahadmanzur
fahadmanzur

Reputation: 61

Excel - Vlookup or Index Match with various criteria

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

Upvotes: 0

Views: 52

Answers (1)

Michal
Michal

Reputation: 5848

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))

Upvotes: 3

Related Questions