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
|