Hi guys,

I have a question,

I have a list of data for example:

columnA columnB
Ak yellow
Bk
Ck green
Dk red
Ek purple
Bk black

Imagine in cell D1 I have "Bk" and I want to index match it on column A and B. the index match will automatically retreive the first value in column B attached with BK being empty thus retreive value "0".

What I would like to add to my formula is an "if result is blank jump to next match"

What should I add to this formula :
=INDEX(B1:B10;match(D1;A1:A10;0))
Thanks!