V look up using match criteria

Hello all

I am trying to identify wow position change between 2 worksheets (doc attached)

The problem i'm having is that a product is sold in 2 colours and i'm unsure to how add an additional match criteria to support this.

=IFERROR((INDEX('week 1'!A:A,MATCH(D4,'week 1'!B:B,FALSE),1)-A4),"")

Thanks in advance

In Week 2!B2 and copied down:

Formula:

Please Login or Register  to view this content.

This is an array formula and must be committed with CTRL-SHIFT-ENTER

Brill, thanks for your help with this one

No problem, thanks for the feedback.