Thanks again. I'm having trouble running the formula though, even though it seems like I'm right on the verge of getting it. Let's say my array is column A, and value I'm trying to find is B2, B3 and so on. Where does the C1 in your formula come into play? And the &"*" ?