TECISM
Technology Education Collaborative
New Post
Change Log
Front Page
About Us
QR Generator
FileShare
MS-200 EXAM
Home
>
Excel
> [XLS]Check if one column value exists in another column using MATCH
[XLS]Check if one column value exists in another column using MATCH
January 16, 2019
epic
Leave a comment
Go to comments
PowerShell
=NOT(ISERROR(MATCH(A2,$B$2:$B$1001,0)))
1
=
NOT
(
ISERROR
(
MATCH
(
A2
,
$B
$
2
:
$B
$
1001
,
0
)
)
)
Categories:
Excel
Tags:
Comments (0)
Trackbacks (0)
Leave a comment
Trackback
No comments yet.
No trackbacks yet.
Name (required)
E-Mail (will not be published) (required)
Website
Subscribe to comments feed
[PS] Hash Map
[TIP] Trouble shooting port 25 smtp in LINUX
Categories
Excel
Exchange
Identity Access Management
Linux
MS-200
MS-500
Networking
Office365
OS
Powershell
Uncategorized
Archives
November 2020
October 2020
September 2020
July 2020
June 2020
March 2020
February 2020
January 2020
October 2019
September 2019
August 2019
July 2019
June 2019
May 2019
April 2019
February 2019
January 2019
October 2018
September 2018
August 2018
June 2018
May 2018
January 2018
December 2017
November 2017
October 2017
September 2017
August 2017
July 2017
June 2017
May 2017
April 2017
March 2017
February 2017
January 2017