V LOOK UP AND IF STATEMENT

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to use a vlookup and if statement to return a value of Y if found and
N if not found i.e. look up the value in column a in another spreadsheet and
put N if not found and Y if found
 
One alternative is something like this in say, C1::
=IF(ISNUMBER(MATCH(A1,B:B,0)),"Y","N")
 
=IF(ISNA(VLOOKUP(...)),"N","Y")

The ISNA() function tests if the expression returns #N/A, which is what
VLOOKUP returns when it does not find what it looks up.

HTH
Kostis Vezerides
 

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

Scrabble Value calculation for Welsh words 0
match formula 2
IF formula help? 5
Multiple IF statement 1
VLOOKUP results in problems in comparing 3
Trying to figure out a formula for range of numbers? 2
Nesting IF/OR Statement 14
VLOOKUP plus IF 1

Back
Top