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,910
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,078,134
Messages
5,338,430
Members
399,232
Latest member
stevenmoritz

Some videos you may like

This Week's Hot Topics

Top