excel - Provide two arguments, get a value from the line that has those two values -

i need this: want have value , when provide 2 arguments : article , color. researched , found match, learned, receives 1 value. how can use 2 values ?

example: article=pants, color=blue.

sample data:

article color   value pants   blue    100 pants   yellow  120 pants   red 60 pants   pink    90 sweater black   30 sweater white   35 

you try utilize concatenate function merge values of both cell , concatenated string.

look @ following image

k8 = match(k7;g8:g13;0)

k9 = index(e8:e13;k8)