Return a "yes" or "no" in vlookup
 

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

Answer: Return a "yes" or "no" in vlookup
 

Yes, you can use the VLOOKUP function in Excel to return a "yes" or "no" answer instead of a column return. Here's the proper syntax:

Here's what each part of the formula means:

1. lookup_value: The value you want to look up in the table.
2. table_array: The range of cells that contains the table you want to search.
3. col_index_num: The column number in the table that contains the value you want to return.
4. FALSE: This tells Excel to look for an exact match of the lookup_value in the table.

The IF function checks whether the VLOOKUP function returns an error (#N/A), which means the lookup_value was not found in the table. If there is an error, the formula returns "no". If there is no error, the formula returns "yes".

Make sure to replace "lookup_value", "table_array", and "col_index_num" with the appropriate values for your specific situation.

Return a "yes" or "no" in vlookup
 

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

On Aug 21, 1:10 pm, wilson@irco
wrote:
Please, what is the proper vlookup syntax to get a yes or no answer in a
vlookup formula, instead of a column return? thanks.

Return a "yes" or "no" in vlookup
 

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



wilson@irco wrote:

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

--

Dave Peterson

Return a "yes" or "no" in vlookup
 

Thanks Pete

"Pete_UK" wrote:

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

On Aug 21, 1:10 pm, wilson@irco
wrote:
Please, what is the proper vlookup syntax to get a yes or no answer in a
vlookup formula, instead of a column return? thanks.

Return a "yes" or "no" in vlookup
 

Thanks Dave.

"Dave Peterson" wrote:

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



wilson@irco wrote:

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

--

Dave Peterson

Return a "yes" or "no" in vlookup
 

You're welcome.

Pete

On Aug 21, 2:14 pm, wilson@irco
wrote:
Thanks Pete



"Pete_UK" wrote:
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

On Aug 21, 1:10 pm, wilson@irco
wrote:
Please, what is the proper vlookup syntax to get a yes or no answer in a
vlookup formula, instead of a column return? thanks.- Hide quoted text -

- Show quoted text -