Please, what is the proper vlookup syntax to get a yes or no answer in a vlookup formula, instead of a column return. I tried some addins but that does not worked. So I need some sample which can state the following in Microsoft Excel.
Please, what is the proper vlookup syntax to get a yes or no answer in a vlookup formula, instead of a column return. I tried some addins but that does not worked. So I need some sample which can state the following in Microsoft Excel.
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. OR 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")
I am not sure about what the exact formula for that is. That can be complicated. I will recommend you to go through the below link in detail to find out how you can do it. The below link contains the complete syntax and detailed information on vlookup.
VLOOKUP
Bookmarks