Given the data in range A1:B6:
black, 2
brown, 1
green, 3
orange, 6
pink, 3
purple, 2
and a set of test values in range D1:D10
green
purple
pink
orange
purple
brown
black
green
orange
pink
When I create an array formula:
{=MATCH(D1:D10,A1:A6,0)}
The formula returns an array...