Vba vlookup

[alpha1200]

What code can i use to
1. Filter column B to "red"
2. Vlookup column C to column E
( So that it only vlookup those filtered red in column B )
3. Delete those #N/A that didn't match ( for red only)
And loop this until cell A and B are blank

Thanks in advance

 

[Joe4]

Welcome to the Board!

I am afraid that your question is not quite clear.
So, I take it that column E is what you want to return (your expected output) from columns A and B?
Is that correct?

If so, why aren't "ultramarine" and "cyan" included?
They have "red" in column B.