G
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.
vlookup formula, instead of a column return? thanks.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
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
=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
D
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")
=if(isnumber(match(a1,sheet2!a:a,0)),"yes - a match","no match")
G
Guest
Thanks Pete
Pete_UK said: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
G
Guest
Thanks Dave.
Dave Peterson said: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")
P