Formula

0

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

Answer
Discuss

Answers

0

Please try this formula in K2. Then copy down.

=COUNTIF(Sheet1!$A:$A,$F2)=0
Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login