Stumped

  • Thread starter Thread starter lightbulb
  • Start date Start date
L

lightbulb

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?
 
=IF(ISNA(VLOOKUP(G9,sheet1!B2:B50)),"","NEW")

Will leave blank if not an exact match.
 
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")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMPRODUCT 00-Jan-00 6
How do I automatically get information from sheet 1 into sheet 2 7
Lookup reference help 3
Help to create a macro 2
Vlookup query 5
Transfering of data from 1 worksheet to another 1
Excel Is this possible?? 3
Create if partial match then copy and paste data from one cell to another 1

Back
Top