THE spirit of Epic TECH.
Login
New Post
Front Page
About Us
QR Generator
FileShare
MS-200 EXAM
Account
Logout
Members
Register
User
[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
)
)
)
Author Details
Author Details
epic
Contributer and Author
Enterprise Communications Engineer
Hi Epic
testest testÂ
theelau@gmail.com
415-000-0000
«
[TIP] Trouble shooting port 25 smtp in LINUX
[PS] Hash Map
»
0
0
votes
Article Rating
Subscribe
Login
Notify of
new follow-up comments
new replies to my comments
Label
{}
[+]
Name*
Email*
Website
Δ
Label
{}
[+]
Name*
Email*
Website
Δ
0
Comments
Inline Feedbacks
View all comments
wpDiscuz
Insert