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] Exchange Online is depreciating Basic Authentication
Dictate in Outlook and Office 365*
[EXO] Various ways to grab all SMTP address from mailbox
[EXO] Concert IMCEAEX string to X500
Notes: 11/21/2020
Recent Comments
[EXO] Exchange Online is depreciating Basic Authentication
Dictate in Outlook and Office 365*
[EXO] Various ways to grab all SMTP address from mailbox
[EXO] Concert IMCEAEX string to X500
Notes: 11/21/2020
Recent Comments