I need to grab values from column A every time a number occurs. So, In column A I have different WO#'s, there are no repeats. In column C I have different Auction Numbers (Several repeats).

Every time, say 39, appears in column C I need to grab the corresponding WO from column A.

Thanks in advance,

Matt