Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
|
|||
|
|||
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:
Code:
=IF(ISNA(VLOOKUP(lookup_value, table_array, col_index_num, FALSE)), "no", "yes")
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.
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
If (A1 = "ValueA" & C1 = "ValueB") return the quantity of matches | Excel Discussion (Misc queries) | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) |