Return a "yes" or "no" in vlookup

[Guest]

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

 

[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

 

[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")

 

[Guest]

Thanks Pete

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

 

[Guest]

Thanks Dave.

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

 

[Pete_UK]

You're welcome.

Pete

Thanks Pete






- Show quoted text -