Lookup and compare

  • Thread starter Thread starter Wayne Burritt
  • Start date Start date
W

Wayne Burritt

Hi: I have a stock symbol is D8 on a worksheet named "July Pick". In E8 of
that sheet, I want excel to search a list of symbols in another sheet and
return "--" if it finds the symbol or "New" if it doesn't. The other sheet
is named "June Pick" and the list of symbols I'd like to search in that
sheet ranges from D8:D27. Any ideas?

Thanks, Wayne
 
Back
Top