Formula

[hdgfss]

i need a vlookup formula
let us suppose data is in sheet1 in column A
and there is a data in sheet2 in column F
formula will be placed in column K of sheet2
the result will be either true or false
what i need is if data of column F of sheet2 does not match with column A data ( not with any cells in column A) then result should be true
if it matches with any one cells or more than one cells of column A then result should be false

 

[jasonb75]

You don't need a vlookup formula for that

=ISERROR(MATCH(F2,Sheet1!$A:$A,0))