Having problem while filling data from a sheet into another.

[Mark00963]

Hello,

I'm trying to get the values of Sizes "S, M, L, XL, and XXL" for sheet named "ANA_STOK" to the sheet named "SS19_STOK_1.1" with two conditions according to the Style Code and Color Name, I tried the LOOKUP function but it keeps giving back the wrong values and not giving any values on some styles!

would you please kindly help me with this?


Thank you!

[Richard Buttrey]

The simpleset way for this sort of request is to create a helper column in the source data which concatenates the Style Code and colour name. If you make that the first column then you can use a simple VLOOKUP function. Otherwise use an =INDEX(MATCH()) combination of functions

[Mark00963]

Would you please kindly teach me how to use the =INDEX(MATCH()) in this case? I'm not familiar with it.

Thanks in advance.

[Richard Buttrey]

See attached - the first SS19 STOK sheet, (I took a second copy of your original) columns K:O & Q:R

[Mark00963]

I don't know how to thank you man;

it perfectly worked and I learned the =INDEX(MATCH()) combination.

[Richard Buttrey]

Excellent. It's a pleasure to have helped.