How to skip blanks with vlookup or IndexMatch...

[Sleeplol]

Hello,
How would I use D1 as lookup value to return the color from column B to E1?

vlookup(D1,A:B,2,False) is returning blank since it's only picking up the first row's value
The same for index(B:B,match(D1,A:A,0))

How do we skip blanks to return the actual values?
Thanks

 

[Fluff]

For 365, how about

=FILTER(B1:B10,(B1:B10<>"")*(A1:A10=D1))

 

[Sleeplol]

THAT'S IT!!!
Thanks Fluff

I haven't used the filter formula before

 

[Fluff]

You're welcome & thanks for the feedback.