Thread
:
Stumped
View Single Post
#
2
Posted to microsoft.public.excel.misc
Sean Timmons
external usenet poster
Posts: 1,696
Stumped
=IF(ISNA(VLOOKUP(G9,sheet1!B2:B50)),"","NEW")
Will leave blank if not an exact match.
"lightbulb" wrote:
I want column W9 of sheet 2 to say NEW if G9 on sheet 2 appears in cells
B2:B50 (exact match, not partial) on sheet 1. Help?
Reply With Quote
Sean Timmons
View Public Profile
Find all posts by Sean Timmons