Return a "yes" or "no" in vlookup

W

wilson@irco

Please, what is the proper vlookup syntax to get a yes or no answer in a
vlookup formula, instead of a column return? thanks.
 
P

Pete_UK

Try this:

=IF(ISNA(VLOOKUP(A1,table,1,0)),"no","yes")

where A1 is the cell with the lookup value, and table is a named range
covering your data.

Hope this helps.

Pete
 
D

Dave Peterson

If you're checking to see if a value is in a single column/row list:

=if(isnumber(match(a1,sheet2!a:a,0)),"yes - a match","no match")
 
W

wilson@irco

Thanks Pete

Pete_UK said:
Try this:

=IF(ISNA(VLOOKUP(A1,table,1,0)),"no","yes")

where A1 is the cell with the lookup value, and table is a named range
covering your data.

Hope this helps.

Pete
Click to expand...
 
W

wilson@irco

Thanks Dave.

Dave Peterson said:
If you're checking to see if a value is in a single column/row list:

=if(isnumber(match(a1,sheet2!a:a,0)),"yes - a match","no match")
Click to expand...
 

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

Newbie Help - IF Yes No Function 0
VLOOKUP returning #N/A ?? 3
VLOOKUP returning #N/A result 2
Formula Returning "False" 1
Help matching combined text cells 1
IF statement with multiple VLOOKUPs 0
vlookup returning #value! 3
V Look up with drop down functionality 5

Top