In Sheet2,
In say, W9: =IF(COUNTIF(Sheet1!B:B,G9),"New","")
That should do it ok. Success? hit the YES below, let me know
--
Max
Singapore
---
"lightbulb" wrote:
This did not work. I want it to say new in column W of sheet 2 if G9 on
sheet 2 appears anywhere in column B on sheet 1. More help?