THE spirit of Epic TECH.
Login
New Post
Front Page
About Us
QR Generator
FileShare
MS-200 EXAM
Account
Logout
Members
Register
User
Excel
[XLS]Check if one column value exists in another column using MATCH
epic
January 16, 2019
Excel
Comment »
Default
=NOT(ISERROR(MATCH(A2,$B$2:$B$1001,0)))
1
=
NOT
(
ISERROR
(
MATCH
(
A2
,
$
B
$
2
:
$
B
$
1001
,
0
)
)
)
Recent Posts
[EXO][PS] Identify if user is part of a big AD Group
[EXO][PS] Find all the Distribution Groups a user is a member of.
[EXO] Setting up Room Finder in a Hybrid Environment
[LINUX] Sending email with CURL
[EXO] Exchange Online is depreciating Basic Authentication
Recent Comments
[EXO][PS] Identify if user is part of a big AD Group
[EXO][PS] Find all the Distribution Groups a user is a member of.
[EXO] Setting up Room Finder in a Hybrid Environment
[LINUX] Sending email with CURL
[EXO] Exchange Online is depreciating Basic Authentication
Recent Comments