Stumped
 

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?

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?

Stumped
 

Hi,
See your other post

"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?

Stumped
 

Vlookup requires 3 arguments and you only have 2 so it will not allow you to
enter it. Additioanlly you have missed the optional 4th argument which means
that it is doing a sorted lookup which may not find the value. Match would be
a better choice for what you are doing instead of Vlookup.

=IF(ISNA(MATCH(G9,Sheet1!B2:B50, 0)),"","NEW")
--
HTH...

Jim Thomlinson


"Sean Timmons" wrote:

=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?