Formula

hdgfss

New Member
Joined
Aug 29, 2019
Messages
20
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

Well-known Member
Joined
Dec 30, 2008
Messages
6,883
Office Version
2019
Platform
Windows
You don't need a vlookup formula for that

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

Forum statistics

Threads
1,077,662
Messages
5,335,564
Members
399,025
Latest member
alce

Some videos you may like

This Week's Hot Topics

Top